Count problem

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
 
G

Gary Keramidas

try counta instead of count. don't know what your data actually looks like,
though.
 
F

Fred Smith

Count counts numbers. As you have text, you need Counta, as in:
=counta(a1:a100)

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

Regards,
Fred
 
Top