Display count of filtered rows
 

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.

Display count of filtered rows
 

=SUBTOTAL(3,A2:A100)


"Eric" wrote:

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.

Display count of filtered rows
 

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


Eric wrote:
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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html