Autofilter record count

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

Guest

When using autofilter in Excel most people receive a record count in the
lower left corner stating how many items were included in the filter (ex: 7
of 15). This feature does not work on my computer most of the time and it
does on my associates machines. We can't figure our why? Any assistance
would be appreciated.
 
When your list has many formulas, or if a cell in the list is changed
after a filter has been applied, the Status Bar may show "Filter Mode"
instead of a count of the visible records. You can use the Subtotal
function to count the visible rows.

The following MSKB article has information:

XL2000: Excel AutoFilter Status Bar Message Shows "Filter Mode"
http://support.microsoft.com/default.aspx?id=213886

And there are a couple of workarounds here:
http://www.contextures.com/xlautofilter02.html#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

Counting Filtered Results Using Autofilter 2
Lost Record count when using Autofilter 1
In Excel, How do I get AutoFilter to provide# of records found? 1
autofilter count 1
How to make the record count always show when using filters... 1
Automatic count for filtered items 4
How can I ensure #records in a selected set always shows in Excel 1
count cells in autofilter 2

Back
Top