Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|