Summing a Field while Using an Autofilter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large spread sheet that i must sort. I currently am using an
autofilter to sort the numbers, then copying the numbers to another sheet and
then summing those numbers. I am doing this because when using the
autofilter if you try and sum at the bottom of a column then you still sum
all the values that are hidden. Is there a way to just sum the visible
numbers when using the autofilter so that i can avoid having to copy and
paste to another sheet. This is really slowing down my program.
 
use
=Subtotal(9,B2:B50)

Subtotal only sums the visible rows from a filter.
 
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

Autofilter and subtotal 1
Eliminate blanks while copy row and transpose 11
Autofilter based on user inputbox 3
Excel Macro to use cells as a autofilter 0
Restore Autofilter After Macro Runs 1
Utilizng full AutoFilter features while specific cells are protect 3
VBA: How can I use a string variable as autofilter criteria? 4
Exclude header row when copying autofilter results? (XL2003) 1

Back
Top