Count problem

[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

 

[Gary Keramidas]

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

 

[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