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