View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default I want to use sumif( a cell reference) and not a value. How?

Try something like this:

With
Col_A containing a list of dates in A1:A50
Col_B containing values in B1:B50

These formulas add the Col_B cells where the corresponding Col_A cells match
the criteria in C1.

C1: (a month name, eg April)
D1: =SUMPRODUCT((TEXT(A1:A50,"mmmm")=C1)*B1:B50)

OR
C1: (a month number, eg 4)
D1: =SUMPRODUCT((MONTH(A1:A50)=C1)*B1:B50)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"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?