Have a look here for cause and workarounds.
http://www.contextures.on.ca/xlautofilter02.html#Count
Gord Dibben MS Excel MVP
On Wed, 27 Jan 2010 03:37:01 -0800, DL101
wrote:
I have set filters on a spreadsheet, usually when I would select a certain
label within the filter list the counter would automatically display at the
bottom of the screen. This does not happen on the spreadsheet that I am
currently working on and I can't see that I am doing anything different to
usual?
Thanks