| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct - Date Range
How do I incorporate a date range into a sumproduct formula.
I would like to add everything up that is greater than 1 date and equal to or less than another. Thanks Rick |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sumproduct - Date Range
you can try this, it sums column C for the dates in Column B
=SUMPRODUCT(--(B1:B4=DATEVALUE("1/1/09")),--(B1:B4<=DATEVALUE("4/1/09")),(C1:C4)) -- Gary Keramidas Excel 2003 "Jackrabbit181" wrote in message ... How do I incorporate a date range into a sumproduct formula. I would like to add everything up that is greater than 1 date and equal to or less than another. Thanks Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct - Date Range | Excel Discussion (Misc queries) | |||
| sumproduct between date range | Excel Worksheet Functions | |||
| Can a date range be used in SUMPRODUCT | Excel Worksheet Functions | |||
| SUMPRODUCT between date range | New Users to Excel | |||
| Sumproduct with date range | Excel Worksheet Functions | |||
Linear Mode
