Count problem
 

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

Count problem
 

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

--

Gary Keramidas
Excel 2003


"PL" wrote in message
...
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

Count problem
 

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

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

Regards,
Fred

"PL" wrote in message
...
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