Sumif Function Help
 

=SUMIF(Month(A3:A30),1,E3:E30)

Why does this not work?
Returns "the formula you typed creates and error"

Thanks
--
Carl 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

SUMIF does not admit array objects, something that Month(A3:A30) would
return...

=SUMPRODUCT(--(Month(A3:A30)=1,E3:E30)

on the other hand would.

BTW, it would be wiser to also add a year test to the formula.

Carl Brehm wrote:
=SUMIF(Month(A3:A30),1,E3:E30)

Why does this not work?
Returns "the formula you typed creates and error"

Thanks
--
Carl 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