|
| 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
September 16th, 2003, 09:56 AM
|
|||
|
|||
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
September 16th, 2003, 10:00 AM
|
|||
|
|||
|
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
September 16th, 2003, 10:35 AM
|
|||
|
|||
|
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
September 16th, 2003, 10:48 AM
|
|||
|
|||
|
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
September 16th, 2003, 12:17 PM
|
|||
|
|||
|
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 | |
|
|
Linear Mode
