Automatic count for filtered items

M

mbparks

How can I assure that the count of filtered items will appear in the lower
left corner in Excel when I apply a filter to a column. I do not want to
have to highlight the column to get the count.

Thank you for your time.
 
S

Sean Timmons

Put your worjksheet calculation in manual. If you have formulas in yoru
workbook, they will calculate on filterand wipe out your count.
 

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

COUNTIF Function on filtered data 2
Filtered Counting 5
Filtered drop down list 2
Using Count Function on Filtered List 1
REPOST: Count certain records in filtered data 5
Counting Filtered Results Using Autofilter 2
count filtered data 1
Count certain records in filtered data 4

Top