SUM IF, Month
 

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.

SUM IF, Month
 

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



"Danny" wrote:

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.

SUM IF, Month
 

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

"CLR" wrote:

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



"Danny" wrote:

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.

SUM IF, Month
 

Thanks a lot.

"Toppers" wrote:

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

"CLR" wrote:

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



"Danny" wrote:

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.