SUM IF, Month

D

Danny

Hi,

I searched on this NG but I can't find a solution to my simple problem.

On Column A are dates, e. i. 09/28/06 format. On column B are values. I'd
like to get the total on Column B if the dates on Column A are days in
September.

Thank you.
 
C

CLR

One way would be to use a helper column. Assuming your dates in column A and
values in column B, then in C2 put this and copy down
=MONTH(a1)
Then in D1 put this
=SUMIF(C:C,9,B:B)

Vaya con Dios,
Chuck, CABGx3
 
T

Toppers

=SUMPRODUCT(--(MONTH(A1:A100)=9),B1:B100)

CLR said:
One way would be to use a helper column. Assuming your dates in column A and
values in column B, then in C2 put this and copy down
=MONTH(a1)
Then in D1 put this
=SUMIF(C:C,9,B:B)

Vaya con Dios,
Chuck, CABGx3
Click to expand...
 
Top