Auto Filter Subtotal
 

When your list has many formulas, the Status Bar may show "Filter Mode"
instead of a count of the visible records. There are articles in the
Microsoft KnowledgeBase that explain:

XL2000: Excel AutoFilter Status Bar Message Shows "Filter Mode"
http://support.microsoft.com/default.aspx?id=213886

XL: AutoFilter Status Bar Message Shows "Filter Mode"
http://support.microsoft.com/default.aspx?id=189479

And a couple of workarounds:
http://www.contextures.com/xlautofilter02.html#Count

Jason wrote:
When using the Auto Filter feature, when you select an item to filter by, on some of my documents it will give me a subtotal at the bottom left hand corner. (5 of 25) I have one document that does not pop up with this subtotal it only says (Ready). Does anyone know how to reactivate the subtotal for filtering?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Auto Filter Subtotal
 

Thank you very much. That was what I needed.