Count for text
 

Hi,

I believe this is very simple, but i fail to make it works.
A
1. text
2. number
3. text
4. text
5. #N/A
6. etc...
50.

I want to count all "text" for column A, please help.

i use =COUNT(IF(ISTEXT(A1:A50);(A1:50)
but result is 1 , not as i expected.

Kind Regards,

Count for text
 

Try
=SUMPRODUCT(--ISTEXT(A1:A10))

--
Jacob


"Pran" wrote:

Hi,

I believe this is very simple, but i fail to make it works.
A
1. text
2. number
3. text
4. text
5. #N/A
6. etc...
50.

I want to count all "text" for column A, please help.

i use =COUNT(IF(ISTEXT(A1:A50);(A1:50)
but result is 1 , not as i expected.

Kind Regards,

Count for text
 

Depending on your definition of "text", you might want Counta, as in:
=counta(a1:a50)

It will count everything but blanks.

Regards,
Fred

"Pran" wrote in message
...
Hi,

I believe this is very simple, but i fail to make it works.
A
1. text
2. number
3. text
4. text
5. #N/A
6. etc...
50.

I want to count all "text" for column A, please help.

i use =COUNT(IF(ISTEXT(A1:A50);(A1:50)
but result is 1 , not as i expected.

Kind Regards,

Count for text
 

Hi Pran just re entered the same text and follow the below format may be it
work.
COUNTIF(A:A,"text")



"Pran" wrote:

Hi,

I believe this is very simple, but i fail to make it works.
A
1. text
2. number
3. text
4. text
5. #N/A
6. etc...
50.

I want to count all "text" for column A, please help.

i use =COUNT(IF(ISTEXT(A1:A50);(A1:50)
but result is 1 , not as i expected.

Kind Regards,

Count for text
 

did get?

"Pran" wrote:

Hi,

I believe this is very simple, but i fail to make it works.
A
1. text
2. number
3. text
4. text
5. #N/A
6. etc...
50.

I want to count all "text" for column A, please help.

i use =COUNT(IF(ISTEXT(A1:A50);(A1:50)
but result is 1 , not as i expected.

Kind Regards,