Sumif Help needed

[Carl Brehm]

=SUMIF(A3:A356,MONTH(TODAY())-1,F3:F356) ' works fine
but
=SUMIF(A3:A356,MONTH()=1,F3:F356) 'does not
=SUMIF(A3:A356,MONTH(A3:A356)=1,F3:F356) 'does not
Really need the second line to work

Why? Is there a way around it, not using sumproduct?

--
Carl & Linda Brehm
Lake Lafourche Bird House
Hebert, LA

Keets, Tiels, GN Lories, Quakers
Mitred Conures, TAG's, Bourkes
Lovebirds, Cherry Head Conures
Prince of Whales

Wholesale Cages to Breeders & Pet Stores

 

[NC]

hi you can try yhe following ARRAY formula.

=SUM(IF(MONTH(A3:A356)=1,F3:F356))

just be sure after entering the formula in formula window press
shift+control+enter & not just enter.

excel will treat this as an array formula and show it as
{=SUM(IF(MONTH(A3:A356)=1,F3:F356))}

hope it solves your problem.

Best Regards
NC

 

[Carl Brehm]

just be sure after entering the formula in formula window press

shift+control+enter & not just enter.

What difference does that make?

 

[NC]

As already specified in message pressing "Shift+control+enter" after
entering formula makes it be treated as array formula

for more on array formulas visit following url

http://www.cpearson.com/excel/array.htm

Regards
NC