Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counta in array formula not working
Hi,
My series B13:B20 contains zero's and text values. I wish to count the text values but not zero's or blanks. I have tried the following as an array but its counting all cells in range with the result = 8 which is not correct (as there are zeros and balnks in the series). =COUNTA(IF(B13:B20<0,"A",0)) Any ideas? Bruce |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counta in array formula not working
How about
=SUMPRODUCT(--(LEN(B13:B20)0),--(B13:B20<0)) Hope this helps, Hutch "Bruce" wrote: Hi, My series B13:B20 contains zero's and text values. I wish to count the text values but not zero's or blanks. I have tried the following as an array but its counting all cells in range with the result = 8 which is not correct (as there are zeros and balnks in the series). =COUNTA(IF(B13:B20<0,"A",0)) Any ideas? Bruce |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counta in array formula not working
Does this do what you want?
=COUNTA(B13:B20)-COUNT(B13:B20) Rick "Bruce" wrote in message ... Hi, My series B13:B20 contains zero's and text values. I wish to count the text values but not zero's or blanks. I have tried the following as an array but its counting all cells in range with the result = 8 which is not correct (as there are zeros and balnks in the series). =COUNTA(IF(B13:B20<0,"A",0)) Any ideas? Bruce |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counta in array formula not working
I wish to count the text values but not zero's or blanks
If blanks means empty cells: =COUNTIF(B13:B20,"*") -- Biff Microsoft Excel MVP "Bruce" wrote in message ... Hi, My series B13:B20 contains zero's and text values. I wish to count the text values but not zero's or blanks. I have tried the following as an array but its counting all cells in range with the result = 8 which is not correct (as there are zeros and balnks in the series). =COUNTA(IF(B13:B20<0,"A",0)) Any ideas? Bruce |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
array formula(s)- not working, need some help please (problem with an 'AND') | Excel Worksheet Functions | |||
Array Formula Not Working with Range with Formulas | Excel Discussion (Misc queries) | |||
COUNTA Formula not working | New Users to Excel | |||
Array formula not working | Excel Worksheet Functions | |||
COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions |