There's information on the record count, and a couple of workarounds, he

http://www.contextures.com/xlautofilter02.html#Count

Frank P. wrote:
With some spreadsheets, I get an indication of how many records are returned
when using AutoFilter. But somketimes I get no such indication.

How can I turn on the # of records retruned by an autofilter operation in
Excel 2003?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html