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!
|