View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Automatic count for filtered items

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.