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?
.
|