| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT - DIFFERENT DATES
Hi,
Please edit my formula below so I can add entries dated 3/30/2007, 4/16/2007 and 5/15/2007 =SUMPRODUCT(--($I$2:$I1116=DATE(2007,3,30)),-($J$2:$J1116=""),$G$2:$G1116) Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct and dates | New Users to Excel | |||
| SUMPRODUCT and Dates | Excel Worksheet Functions | |||
| sumproduct between dates | Excel Worksheet Functions | |||
| Sumproduct using dates | Excel Worksheet Functions | |||
| SUMPRODUCT ON DATES | Excel Worksheet Functions | |||
Threaded Mode
