| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting and subtotal in a filtered list
When I sort and then subtotal a filtered list, the subtotal does not always
subtotal the entire list of records that have the field that I sorted on. Sometimes I may have several subtotals that I need to add up. What is happening here and is there any way to fix this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting and subtotal in a filtered list
I always remove the existing subtotals (created by data|subtotals, right???).
Then I sort the way I want and reapply the data|subtotals. Ken W wrote: When I sort and then subtotal a filtered list, the subtotal does not always subtotal the entire list of records that have the field that I sorted on. Sometimes I may have several subtotals that I need to add up. What is happening here and is there any way to fix this? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting a subtotal list by the subtotals | Excel Discussion (Misc queries) | |||
| How to make "countif" on a filtered excel-list? i.e. like subtotal | Excel Worksheet Functions | |||
| subtotal only unique in filtered list | Excel Discussion (Misc queries) | |||
| How do I insert a filtered subtotal into overall summary | Excel Discussion (Misc queries) | |||
| Subtotal function with Filtered Data | Excel Discussion (Misc queries) | |||
Linear Mode
