Thread: Count for text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rohinikumar Rohinikumar is offline
external usenet poster
 
Posts: 32
Default 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,