Autofilter and subtotal

  • Thread starter Thread starter stevefromnaki
  • Start date Start date
S

stevefromnaki

Hi,

I have applied an autofilter to my table. Within the table i have several
sections which are subtotaled using =subtotal(9, range).

When I apply an autofilter there is no value for subtotal as the rows that
it subtotals are hidden by the autofilter.

I can get around this if I use =sum(range) but I prefer to use the subtotal
formula.

Is there a way around this??
 
The intention of Subtotal is to apply the function to the visible cells
only. If that is not what you want the Sum is the way to go.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subtotals give zero 2
Want to blank some cells when an AutoFilter is active. 9
AutoFilter and Sub-total 6
Subtotal Formatting 2
Calculating subtotals 22
I need ONLY subtotals copied to a second sheet 4
percent of row in subtotal range 1
Cleaner coding to repeat process 6

Back
Top