=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