A simple one on the surface of it, but I couldn’t find a quick answer. Hopefully this saves you some time
Let’s say you have a Google Sheet where you have a bunch of rows, and you want to count the total number of rows in a range dynamically. In other words, when you add another row of text, the count should update.
How can you do this?
The magic formula is to use
COUNT works fine if your data is numeric.
However, if your data is not numeric, like the
rowX line in column B above, you need to use
Here I have used
=counta(B1:B44), which gives 16.
That’s fine, but what if you want every entry in column B?
Well, one way is just to whack in a suitably large number. Like
=counta(B1:B44444). But a better way is just to use
So you could count literally every row with
Or it may be that the first row is your headers, so a better version might be
Anyway, it worked for me. And hopefully it saves you some hair loss if you’re trying to figure that out also.