Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

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!

Re: Count entries that have been filtered

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

=SUBTOTAL(3,reference)

Re: Count entries that have been filtered

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

Awesome! Thanks so much again, Mark!
Merle

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.