How to sum a column based on the choice of autofilter?

  • Thread starter Thread starter Mr.G
  • Start date Start date
M

Mr.G

Hello,
I must sum the columns based on the criteria I choose in
the autofilter.Does anyone have a clue how to to
this.Hence, I only want to sum the visible cells.

I appreciate all respons.
Mr.g
-up north
 
All of the Subtotal functions work on filtered data (visible cells only)
 
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

SUM - IF - AND 7
Autofilter based on user inputbox 3
autofilter macro 1
How to set range to autofiltered visible cells? 7
Summing a Field while Using an Autofilter 1
Sum Columns with Specific Headings 6
How do I sum a column based on 2 different column headers/criteria? 0
Excel Macro to use cells as a autofilter 0

Back
Top