Automatic count for filtered items

[mbparks]

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.

 

[Sean Timmons]

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

 

[mbparks]

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

 

[Sean Timmons]

Sorry for the spelling. Thank you for telling us it worked!

 

[Gord Dibben]

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