MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Count entries that have been filtered


Posted by Mason on February 15, 2001 3:41 PM

I have a column "State" with different U.S. States. I would like to count how many users are in CA. When I do an autofilter the row labels show the row number of each CA (so 2,3,5,9, etc). Anyway I can count the users in CA? Thanks!


Posted by Mark W. on February 15, 2001 3:46 PM

=SUBTOTAL(3,reference)

Posted by Mason on February 16, 2001 9:13 AM

Awesome! Thanks so much again, Mark!
Merle