Sumproduct w/ month and year

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(YEAR(A1:A100)=2004),--(MONTH(A1:A100)
=5),B1:B100)

 

[Frank Kabel]

Hi
=SUMPRODUCT(--(YEAR(A1:A100)=2004),--(MONTH(A1:A100)=5),--
(B1:B100>1000),B1:B100)