| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct of date range
Hello,
I use this formula to sumproduct for one date range: =Sumproduct(--(Text(Overall!H8:H2200,"mmm/yyyy")=Text(A1,"mmm/yyyy"))) I know it reads "text" but it works. What do I need to add to this formula in order for it to calculate more than one date range? Thanks. Roy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT with Date Range | Excel Worksheet Functions | |||
| Sumproduct - Date Range | Excel Discussion (Misc queries) | |||
| Sumproduct on date range | Excel Discussion (Misc queries) | |||
| sumproduct between date range | Excel Worksheet Functions | |||
| Sumproduct with date range | Excel Worksheet Functions | |||
Threaded Mode
