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

and has some work arounds there, too.

Al wrote:

I have Excel 2002 running on two different machines and they display
different messages on the left side of the status bar when I use the filter.
One shows how many rows are filtered out of the total (which I want to see)
and the other just says "Ready". I thought this might be controlled in the
Options dialog box, but I don't see it. How is this controlled?

--

Dave Peterson