| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with sum based on dates
I have a column that contains dates & quantities I would like to sum based on
date ranges that I would define. For example I would want the sum quantities whose dates fall in-between Nov. 11 & Nov 17. Nov. 18 & 24€¦.. So on & so forth. I have been trying to figure out a way to do this with maybe a v lookup or pivot table. However I have not been able to do so. If anyone has any ideas as to how I can do what I want to do I would be very grateful. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing, VB - based on dates | Excel Worksheet Functions | |||
| Sum based on the dates in a different row. | Excel Worksheet Functions | |||
| how to sum up or count based on dates | New Users to Excel | |||
| how to sum up based on dates | Excel Discussion (Misc queries) | |||
| Averages based on dates | Excel Worksheet Functions | |||
Threaded Mode
