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