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