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.