If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
help with SumIF
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 |
#2
|
|||
|
|||
help with SumIF
"Radeesh" wrote in message
... 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 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) |
#3
|
|||
|
|||
help with SumIF
Thanks
that worked! Radeesh "Anon" none wrote in message ... "Radeesh" wrote in message ... 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 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) |
#4
|
|||
|
|||
help with SumIF
On Tue, 16 Sep 2003 14:26:33 +0530, "Radeesh" wrote:
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 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 |
#5
|
|||
|
|||
help with SumIF
Thank you Ron
Radeesh "Ron Rosenfeld" wrote in message ... On Tue, 16 Sep 2003 14:26:33 +0530, "Radeesh" wrote: 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 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 |
Thread Tools | |
Display Modes | |
|
|