Hi,

Why not =COUNTIF(A:A,"*") instead

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Teethless mama" wrote in message
...
=COUNTIF(A:A,"?*")


"smaruzzi" wrote:

I want to dynamically calculate the number of entries in a list of text
strings. Surprisingly COUNTA returns a number not corresponding to the
actual
number of strings in a range of cells. I tried to revert to COUNTIFS but
cannot determine the correct syntax for the concept "is not null/empty".

Any suggestions? I use Excel 2008 for Mac.

Thanks, Stefano