Finding how many entries in a column

To find out how many entries there are in a column you can use

=COUNTA(A:A)

This will display how many entries there are in column A.

This is different from the COUNT function which only counts numerical values.

Related Posts