3

I have a table that looks like this:

Column A

Dog     
Apple   

And some more words. But on the side of the table, I want to have a cell which tells me how many rows I have in Column A, and I want it to update as I add more rows. How could I do this using equations or functions?

0

3 Answers 3

7

=COUNTA(A:A)-1 will return the number of non-blank cells in Column A.

2
  • Ah, good one with the minus 1. Sep 8, 2011 at 23:18
  • Don't put that formula in the column being counted. That will produce a circular reference error. May 3, 2022 at 20:24
1

If you don't mind the header cell being counted you could just use:

=COUNTA(A:A)
0
0

If your rows contain text you will need {=COUNT(IF(A:A<>"",1,0))}

It needs to be entered as an array formula. You might also need to subtract some value from this to account for header rows.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .