Debra Dalgleish explains it and gives some alternatives:
http://contextures.com/xlautofilter02.html#Count

Sameer wrote:

Dear All,
I have auto filtered my list.
Whenever I apply a particular filter to a list, it gives me
## of ## records found on the status bar.
But this is not the case always.
Sometimes it gives the 'Filter Mode' as the status. This is happening
for some sheets.
Why this may happen?
Any settings to do?
Please explain.

-Sameer

--

Dave Peterson