SUM IF, Month

[Guest]

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.

 

[Guest]

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

 

[Guest]

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

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

 

[Guest]

Thanks a lot.

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