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.
 
Back
Top