| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Threaded Mode
