Autofilter and subtotal
 

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??

Autofilter and subtotal
 

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.

--
Regards,

OssieMac


"stevefromnaki" wrote:

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??