View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers
 
Posts: n/a
Default 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?