Count problem

  • Thread starter Thread starter PL
  • Start date Start date
P

PL

I have a list of countries all in their own rows. I would like to count the
number of countries I have how do I do so?

I tried the below, however I only have back 0. Does this formula work with
letters?

"you can use =count(a1:a100), if counties appear from cell a1 downwards"

Thank you
 
try counta instead of count. don't know what your data actually looks like,
though.
 
Count counts numbers. As you have text, you need Counta, as in:
=counta(a1:a100)

or, more simply:
=counta(a:a)

Regards,
Fred
 
Back
Top