Determining number of entries in a table
 

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

Determining number of entries in a table
 

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

Determining number of entries in a table
 

=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

Determining number of entries in a table
 

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