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
|
|||
|
|||
SUMIF cells in column contain specific month
Assume that column A (rows 2-7)has dates in it and Column
B (rows 2-6)has $ amounts. I want to sum the amounts in Column B for those rwos where the month in column A is March. The formula "=SUMIF(MONTH(A2:A7),3,B2:B7)" doesn't work. Can anyone help? |
#2
|
|||
|
|||
SUMIF cells in column contain specific month
Hi
try =SUMPRODUCT(--(MONTH(A2:A7)=3),B2:B7) -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... Assume that column A (rows 2-7)has dates in it and Column B (rows 2-6)has $ amounts. I want to sum the amounts in Column B for those rwos where the month in column A is March. The formula "=SUMIF(MONTH(A2:A7),3,B2:B7)" doesn't work. Can anyone help? |
#3
|
|||
|
|||
SUMIF cells in column contain specific month
Hi aploshnick!
One way: =SUMPRODUCT(--(MONTH(A1:A7)=3),(B1:B7)) MONTH(A1:A7)=3 is an implicit IF statement and the -- coerces the response of TRUE and FALSE to 1 and 0. -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. wrote in message ... Assume that column A (rows 2-7)has dates in it and Column B (rows 2-6)has $ amounts. I want to sum the amounts in Column B for those rwos where the month in column A is March. The formula "=SUMIF(MONTH(A2:A7),3,B2:B7)" doesn't work. Can anyone help? |
#4
|
|||
|
|||
SUMIF cells in column contain specific month
A million thanks
-----Original Message----- Hi aploshnick! One way: =SUMPRODUCT(--(MONTH(A1:A7)=3),(B1:B7)) MONTH(A1:A7)=3 is an implicit IF statement and the -- coerces the response of TRUE and FALSE to 1 and 0. -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. wrote in message ... Assume that column A (rows 2-7)has dates in it and Column B (rows 2-6)has $ amounts. I want to sum the amounts in Column B for those rwos where the month in column A is March. The formula "=SUMIF(MONTH(A2:A7),3,B2:B7)" doesn't work. Can anyone help? . |
Thread Tools | |
Display Modes | |
|
|