count rows of a filtered list

[Tim]

Hi I am often counting rows in a list that has been filtered. is there
an easy way of finding out how many are in the filtered row, thanks tim

 

[Debra Dalgleish]

You can use the SUBTOTAL function to count the filtered rows. There's
information in Excel's Help, and here:

http://www.contextures.com/xlFunctions04.html#Filter

For example: =SUBTOTAL(3,B2:B400)