how to get count of rows in the spreadsheet?

Question

In google spreadsheets, after typing in a list of items through cells A1 to A7, I went off to another cell and typed the following formula

=COUNT(A1:A7)

It reports zero, instead of seven.

I've done exactly what this article does, but still not the correct result.

Would you please give us the exact data you typed in cells? Please pay attention that COUNT function only counts numeric values — Nima, Jul 19 '14 at 16:54

Nima · Accepted Answer · 2014-07-19 18:00:35Z

2

According to https://support.google.com/docs/answer/3093620 COUNT function only counts numeric values. Try COUNTA and it should do the job (explained here https://support.google.com/docs/answer/3093991)

answered Jul 19 '14 at 18:00

Nima

3881 silver badge11 bronze badges

Add a comment |

1 Answer 1