Take a look at Debra Dalgleish's site:
http://www.contextures.com/xlautofilter02.html#Count

She has a couple of workarounds.

SReed wrote:

I have applied filters to an excel spreadsheet. When I select a value from
the filter drop down it used to display the count or total number of records
inthe filtered list in the botton right hand corner.

Now, for some reason it still filters but it DOESNT display the count of
records, instead it displays Filter Mode. This has happened for years but
only now have I decided to ask why! Please can someone tell me what I am
doing wrong!

--

Dave Peterson