Don't forget to renable auto-calc.

I would suggest a couple other workarounds that don't involve changing
calculation mode back and forth.

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


Gord Dibben MS Excel MVP

On Thu, 2 Oct 2008 10:02:07 -0700, mbparks
wrote:

As always, Thank you for your quick response. This solved the mystery.

"Sean Timmons" wrote:

Put your worjksheet calculation in manual. If you have formulas in yoru
workbook, they will calculate on filterand wipe out your count.

"mbparks" wrote:

How can I assure that the count of filtered items will appear in the lower
left corner in Excel when I apply a filter to a column. I do not want to
have to highlight the column to get the count.

Thank you for your time.