Hi,

This ignore NULL strings

=SUMPRODUCT(--(A1:A100<""))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"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