SUM a range based on month

[lunker55]

I need to SUM a range of cells only if it is in a certain month.

=SUMIF(sheet1!A4:A10000,">="&DATE(2004,2,1),values)

This formula sums all months from Feb 1 on. I only want February.

Is there a way to enter the end date in my formula?

I need to do this for every month.

Joe

 

[Jason Morin]

=SUMPRODUCT(--(TEXT(Sheet1!A4:A10000,"mmm")="Feb"))

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(YEAR(A4:A10000)=2004),--(MONTH(A4:A10000)=2),values)

 

[lunker55]

Thanks Frank and Jason.
Do you need those dashes when entering a date?
Now I need to combine a few formulas. I'll post if I can't figure it
out(probably can't).

Joe