See Debra Dalgleish's site for info and workarounds.

http://www.contextures.on.ca/xlautofilter02.html#Count


Gord Dibben MS Excel MVP

On Mon, 30 Jul 2007 11:08:00 -0700, James
wrote:

Oftentimes when I use filters in Excel, it'll show me a count (in the lower
corner) of what I am filtering. Sometimes this doesn't happen. Does anyone
know why? Is there a setting I need to change?