| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct help using dates as the criteria
I'm having trouble figuring how to work with dates in one column as the
criteria to add amounts in another column. The desired outcome is to add those amounts in column B that occur between two dates (say, between 2/26/09 and 5/10/09). I've used the following formula but get #VALUE for an answer: =SUMPRODUCT(--(A16:A421=1/1/09),--(A16:A421<2/1/09),--(I16:I421)) This is using Excel 2003. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT with 3 criteria | Excel Discussion (Misc queries) | |||
| add two criteria that should not be met to sumproduct | Excel Worksheet Functions | |||
| SUMPRODUCT using more than 2 criteria? | Excel Worksheet Functions | |||
| Sumproduct - two+ criteria | Excel Worksheet Functions | |||
| Sumproduct with two criteria | Excel Worksheet Functions | |||
Threaded Mode
