Count for text

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,
 
F

Fred Smith

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

It will count everything but blanks.

Regards,
Fred
 
R

Rohinikumar

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Loop 0
Formating bolded text exclusively. 0
Macro to Select text from a point given to a specific word 2
Count number of rows with specific text 2
how to count rows if 2 columns partially match 5
Finding the right style field in VBA 0
Grow/Shrink Text gradually from slide to slide 0
Finding the proper style field and the numbered paragraph value within the style 0

Top