Autofilter and subtotal

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

OssieMac

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

Subtotal Formatting 2
Want to blank some cells when an AutoFilter is active. 8
Macro to copy subtotaled data 10
Autofilter problem 9
AutoFilter and Sub-total 6
Excel 2013: AutoFilter and SUM() 1
subtotals give zero 2
Macro Pause to Select range then Subtotal 0

Top