How do I count the number of records autofilter is showing in Exce
 

I want to have a count of the number of records that autofilter selects. That
number showed at the bottom of the screen when I first began using Excel (not
sure what version; before 2000 anyway), but now, it seems to have disappeared.

How do I count the number of records autofilter is showing in Exce
 

look in the help index for SUBTOTAL

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Patricia O''Donnell SSJ"
wrote in message ...
I want to have a count of the number of records that autofilter selects.
That
number showed at the bottom of the screen when I first began using Excel
(not
sure what version; before 2000 anyway), but now, it seems to have
disappeared.

How do I count the number of records autofilter is showing in Exce
 

=SUBTOTAL(2,A1:A100)
--
Gary''s Student - gsnu200908


"Patricia O''Donnell SSJ" wrote:

I want to have a count of the number of records that autofilter selects. That
number showed at the bottom of the screen when I first began using Excel (not
sure what version; before 2000 anyway), but now, it seems to have disappeared.

How do I count the number of records autofilter is showing in Exce
 

See this:

http://contextures.com/xlautofilter02.html#Count

--
Biff
Microsoft Excel MVP


"Patricia O''Donnell SSJ"
wrote in message ...
I want to have a count of the number of records that autofilter selects.
That
number showed at the bottom of the screen when I first began using Excel
(not
sure what version; before 2000 anyway), but now, it seems to have
disappeared.