help with SumIF

  • Thread starter Thread starter Radeesh
  • Start date Start date
R

Radeesh

Hi
I have some dates in Col i and ammount in Col j

I want use SumIf to add all the amounts in a given month

=SUMIF(MONTH(I4:I13),MONTH(B20),J4:J13)

this is the formula i am trying but it says "you have an error in your
formula" and refuses to let me enter the formula even tried {} and
Ctrl+shift+enter

please help

TIA

Radheesh
 
Radeesh said:
Hi
I have some dates in Col i and ammount in Col j

I want use SumIf to add all the amounts in a given month

=SUMIF(MONTH(I4:I13),MONTH(B20),J4:J13)

this is the formula i am trying but it says "you have an error in your
formula" and refuses to let me enter the formula even tried {} and
Ctrl+shift+enter

please help

TIA

Radheesh
Click to expand...

I think the first parameter of SUMIF must be a range, not a function of a
range.
For example, I4:I13 would be OK but MONTH(I4:I13) is not.
Instead try
=SUMPRODUCT((MONTH(I4:I13)=MONTH(B20))*J4:J13)
 
Thanks
that worked!

Radeesh

Anon said:
I think the first parameter of SUMIF must be a range, not a function of a
range.
For example, I4:I13 would be OK but MONTH(I4:I13) is not.
Instead try
=SUMPRODUCT((MONTH(I4:I13)=MONTH(B20))*J4:J13)
Click to expand...
 
Hi
I have some dates in Col i and ammount in Col j

I want use SumIf to add all the amounts in a given month

=SUMIF(MONTH(I4:I13),MONTH(B20),J4:J13)

this is the formula i am trying but it says "you have an error in your
formula" and refuses to let me enter the formula even tried {} and
Ctrl+shift+enter

please help

TIA

Radheesh
Click to expand...

For the month of February 2003:

=SUMIF(I4:I13,">="&DATE(2003,2,1),J4:J13) -
SUMIF(I4:I13,"<"&DATE(2003,3,1),J4:J13)


--ron
 
Back
Top