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 your sheeeeets.