I want to use sumif( a cell reference) and not a value. How?
TRY:
=SUMPRODUCT(--(MONTH(A1:A100)= C1),--(B1:B100))
A contains dates
B values to be summed
C1= month number e.g 4 for April
Assumes data only relates to one year.
"Corie" wrote:
I want to use the sumif( a cell referenced Date)
Example: sumif(""&C1) when C1= April, in order to sum numbers related to a
specific time frame.
Is there a way to do this w/ dates?
|