Autofilter Subtotal

  • Thread starter my.wandering.mind
  • Start date
M

my.wandering.mind

Hi All,

I have a table in which I am performing an autofilter for column d and
then I would like to find the total across each column in the
remaining visible rows.
Then I would like to generate a new table with these totals across
columns for the selected filter criteria.

Can anyone help me with this?

I have been stuck in this for a while now.

Thanks
vishnu
 
R

Roger Govier

Hi Vishnu

Insert a row above your Autofilter
Use the Subtotal function
=SUBTOTAL(9,D3:D1000)
Change the range to suit
Copy across to any other columns required.
 

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

Eliminate blanks while copy row and transpose 11
List all tables, including document structure 0
How to set range to autofiltered visible cells? 7
Autofilter tables Uniquelist 8
Autofilter and subtotal 1
Autofilter problem 9
autofilter average values 2
I need ONLY subtotals copied to a second sheet 4

Top