Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtotal not showing after filtering list
Using Excel 2003 SP3 Professional Edition
I have a large spreadsheet that has a subtotal at the end of the data (=subtotal(9,K4:K4000). I have many different values that I filter on that I like to see the subtotal at the bottom of the filtered list. One day this was working and the next day it wasn't. What is happening now is the subtotal line is being hidden when the filter is on. Can anyone help me figure out how to get it not to hide? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal Levels not showing in Excel | Excel Worksheet Functions | |||
Pivot Table: showing data as % of subtotal | Excel Discussion (Misc queries) | |||
Filtering a column, where it stopped showing records | Excel Worksheet Functions | |||
Auto filtering vs Date List Create List | Excel Worksheet Functions | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions |