Debra Dalgleish explains it and offers a workaround:
http://contextures.com/xlautofilter02.html#Count
Walldorc wrote:
How do I get Auto filter to report number of records filtered in bottom left
hand corner of screen. I have seen this before but the spread sheet I am
using at the moment just changes from ready to filter mode?
--
Dave Peterson