Record COUNT missing when using Auto-Filter??

J

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;-)
 
K

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,
 
J

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;-)
 
Top