From: smaruzzi on 7 Mar 2010 04:59 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 From: Mike H on 7 Mar 2010 05:09 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 From: Teethless mama on 7 Mar 2010 10:21 =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 From: Ashish Mathur on 15 Mar 2010 09:04 Hi, Why not =COUNTIF(A:A,"*") instead -- Regards, Ashish Mathur Microsoft Excel MVP "Teethless mama" wrote in message news:6C8A99EE-25B2-4E90-96B6-65F575FE75F1(a)microsoft.com...> =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  |  Pages: 1 Prev: Looking up name with 2 criteriaNext: Matching function or no match