When you apply an autofilter to a table or a cell range, you can use the SUBTOTAL function to count just the visible rows. The SUBTOTAL function is multiple functions built in one function with different methods (AVERAGE, COUNT, COUNTA, MAX, MIN, SUM, etc).
In this tutorial I am going to show you how to use the SUBTOTAL function to count just the visible rows/cells.
[table id=2 /]