| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum based on ranges pivot table?
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 | |||
| Pivot Table Ranges | Excel Discussion (Misc queries) | |||
| Pivot Table Data Ranges | Excel Discussion (Misc queries) | |||
| Pivot table based on amount ranges. | Excel Programming | |||
| Pivot Table - consolidating ranges (again) | Excel Discussion (Misc queries) | |||
| using date ranges in a pivot table | Excel Programming | |||
Threaded Mode
