Display count of filtered rows

[Guest]

I think I recall that at one time Excel used to automatically display a count
of the number of rows resulting from a filter, in the Excel status bar at the
bottom of the screen. However, it does not do that for me now.

Is my recollection wrong, or is there an option that I need to turn on?

Thanks.

 

[Guest]

=SUBTOTAL(3,A2:A100)

 

[Debra Dalgleish]

When your list has many formulas, the Status Bar may show "Filter
Mode"instead of a count of the visible records. You can use the Subtotal
function to count the visible rows.

The following MSKB article has some information:

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

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