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
|