Sumif for Date Range

[Guest]

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!

 

[Guest]

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)

 

[Guest]

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

 

[JE McGimpsey]

One way:

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