Determining number of entries in a table

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
 
M

Mike H

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

row number of last non-blank cell 14
Counting cell entries 4
Function in Excel to count and list number of entries of text valuesin a row. 2
Counting cells in a selectable date range 0
TOTAL NUMBER OF ENTRIES 5
Count Number of occurences of several texts in a range of cells 3
How do you determine a total number of worksheet entries? 4
Determining the text mode from a variety of data types 17

Top