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

[Patricia O''Donnell SSJ]

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.

 

[Don Guillett]

look in the help index for SUBTOTAL

 

[Gary''s Student]

=SUBTOTAL(2,A1:A100)

 

[T. Valko]

See this:

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