Determining number of entries in a table

  • Thread starter Thread starter smaruzzi
  • Start date Start date
S

smaruzzi

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
 
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.
 
Back
Top