| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
BETWEEN DATES SUM
=SUMIF(A1:A9,"<="&DATE(2004,4,2),B1:B9)-SUMIF(A1:A9,"<"&DATE(2004,3,29),B1:B9)
Try something like the above. A1:A9 would reference your dates to be summed. B1:B9 references the column to be summed due to the specified date range. Of course you would need to set your range in the identical format. Hope this helps you out -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ploting dates against a calendar and not as a simple events | Charts and Charting in Excel | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
| Entering dates in Excel 2002 | Excel Discussion (Misc queries) | |||
| I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) | |||
| Filtering with dates | Excel Discussion (Misc queries) | |||
Hybrid Mode
