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


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
  • Data is a list of names...
    – deostroll
    Jul 19 '14 at 17:34

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)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.