fbpx

How Do I Count Visible Rows When Using Filters in Google Sheets?

Let’s say you have a table like this:

To find out how many animals are in the unfiltered view you can manually select all rows in the table and look to the bottom right:


But there has to be a better way, right?

Yeah!

Let’s just use the Power of Formulas!

We will use SUBTOTAL.

And now we count those rows!

Optionally, you can concatenate number with a text in the top row cell so you can view the number right at the top:

Enjoy.

 

3 thoughts on “How Do I Count Visible Rows When Using Filters in Google Sheets?

  • Hello, I would like to use this formula but with specific criteria, for example only count the visible cells that show “N/A”. It seems to be difficult with Google Sheets. Thanks!

    • Hi Rachel, first I would filter rows with “N/A” (you can filter data and select only the values you want using checkboxes) and then I would use the advice in this article to count ’em.

Leave a Reply

Leave a Reply

Your email address will not be published.