Debra Dalgleish explains it he
http://contextures.com/xlautofilter02.html#Count

and has some work arounds there, too.

Erika wrote:

In Excel when I filtered records it use to show me in the status bar how many
records were showing when the filter was applied, for some reason I lost that
and I can not get it back

--

Dave Peterson