Count for text

  • Thread starter Thread starter Pran
  • Start date Start date
P

Pran

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,
 
Depending on your definition of "text", you might want Counta, as in:
=counta(a1:a50)

It will count everything but blanks.

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