|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 7th, 2010, 09:59 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
March 7th, 2010, 10:09 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#3
March 7th, 2010, 03:21 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#4
March 15th, 2010, 01:04 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
