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

and has some work arounds there, too.

jlt wrote:

When I filter records in Excel the number of records are not displayed on the
Status Bar. I am expecting results i.e. 5 of 50 records. All I see is
"Filter Mode". How do I correct to display 5 of 50 records??

--

Dave Peterson