Sumif for Date Range
 

Hello-

Column A dates and Column C is what I want to sum. If the dates are between
1-1-07 and 1-31-07 I want to sum Column C. But I want to set up the formula
so I can change the month that is being summed easily. Here is my attempt to
do a sumif with a range:

=sumif(A:A,"=39141"&"<=39173",C:C)

It doesn't work, any help? Thanks!

Sumif for Date Range
 

TRY:

=SUMPRODUCT(--(MONTH(A1:A100)=1),C1:C100)

=SUMPRODUCT(--(MONTH(A1:A100)=X1),C1:C100)

1=Jan, 2=Feb etc

X1 contains 1, 2 etc

Ranges cannot be whole columns (except Excel 2007)

"Raza" wrote:

Hello-

Column A dates and Column C is what I want to sum. If the dates are between
1-1-07 and 1-31-07 I want to sum Column C. But I want to set up the formula
so I can change the month that is being summed easily. Here is my attempt to
do a sumif with a range:

=sumif(A:A,"=39141"&"<=39173",C:C)

It doesn't work, any help? Thanks!

Sumif for Date Range
 

My sheet has more than one January, how do I sum January 07 only?

"Toppers" wrote:

TRY:

=SUMPRODUCT(--(MONTH(A1:A100)=1),C1:C100)

=SUMPRODUCT(--(MONTH(A1:A100)=X1),C1:C100)

1=Jan, 2=Feb etc

X1 contains 1, 2 etc

Ranges cannot be whole columns (except Excel 2007)

"Raza" wrote:

Hello-

Column A dates and Column C is what I want to sum. If the dates are between
1-1-07 and 1-31-07 I want to sum Column C. But I want to set up the formula
so I can change the month that is being summed easily. Here is my attempt to
do a sumif with a range:

=sumif(A:A,"=39141"&"<=39173",C:C)

It doesn't work, any help? Thanks!

Sumif for Date Range
 

One way:

=SUMPRODUCT(--(MONTH(A1:A100)=1),--(YEAR(A1:A100)=2007),C1:C100)

In article ,
Raza wrote:

My sheet has more than one January, how do I sum January 07 only?