Automatic totalling of autofiltered lists

K

ken

HI,
I have tried to find out on my own. Please help.


I have a list of items that lets say I do a top then
autofilter on....How can I get that empty cell under them
to total only what shows up on the filter? Then when I
change the filter it would then recalculate whatever is
fits the filter's criteria in the AUTOfilter.
Any help would be appreciated.
Thanks.
Ken
 

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

emailing autofilter results 3
remembering the same filtering criteria 13
autofilter results based on cell input 5
Trying to figure the formula 1
custom autofilter 3
how can I make autofilter automatically update 2
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Enabling Autofilter and Sorting in a Protected Sheet 2

Top