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

Rick Gomes wrote:

When an auto-filter is turned on, why is it that sometimes the Status Bar (at
the bottom-left portion of the screen) shows the filtered number of records
against the total number of filtered records (i.e.: 50 of 150 records found)
while other times it does not?

This is extremely frustating.

What can I do to guarantee that this extremely valuable auto-filter feature
works 100% of the time?

Thanks,

Rick

--

Dave Peterson