Total when filtered

  • Thread starter Thread starter LL
  • Start date Start date
Look in the help index for SUBTOTAL and read carefully about the code for
filtered.
 
If you are using XL2003 or later, you can use:

=SUBTOTAL(109,range)

which will ignore hidden rows caused both by autofilter and manually-
hidden.

Earlier versions are limited to:

=SUBTOTAL(9,range)

which ignores autofiltered hidden rows.

Hope this helps.

Pete
 
Apply a filter before using the Autosum button, and Excel will create the
proper subtotal formula for you. Instead of =sum(range), it will be
=subtotal(9,range)
 
You must log in or register to reply here.

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

hidden rows problem 7
Sum after Filter, Count after Fliter 2
Summary 2
sum of visable cells in filtered range 7
filtering subtotals and if functions 2
FILTERING RESULTS 5
Total Adblocker 4
total on filtered data? 3

Back
Top