Record COUNT missing when using Auto-Filter??

[Jennifer]

When I use Auto-Filter on my spreadsheet, and then
actually filter one of the columns, is there a way I can
have Excel tell me the number of matching records?

For some reason, I thought this used to show up in the
status bar (lower left), but I can't get it to tell me
the number of matching records anymore.

HELP! Thanks a bunch! -JEN;-)

 

[Ken Wright]

Just use SUBTOTAL(3,Range) on any range that will always have data in it in your
records. This simply counts the non-blank records in any range so by default
will give you a count of your filtered data,

 

[Frank Kabel]

Hi Jennifer
use
=SUBTOTAL(3,A1:A1000)

 

[Gord Dibben]

Jen

Debra Dalgeish has KB info on the cause of this problem and a couple of
work-arounds similar to Frank's and Ken's.

http://www.contextures.on.ca/xlautofilter02.html#Count

Gord Dibben Excel MVP

 

[Jennifer]

Thank You everyone, for the assistance! I ended up using
the "easy" way -- just changing the calculation option
to "manual" temporarily.

Thanks again! -JEN;-)