SUMIF cells in column contain specific month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.
Click to expand...
 
Back
Top