Prev: How do i change a digit into word i,e 1 = one
Next: Excel 2007 Macro/VB Question DDE Question
From: Pran on 24 Feb 2010 01:42
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,



From: Jacob Skaria on 24 Feb 2010 02:10
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,
>
>
>
From: Fred Smith on 24 Feb 2010 11:51
Depending on your definition of "text", you might want Counta, as in:
=counta(a1:a50)

It will count everything but blanks.

Regards,
Fred

"Pran" <Pran(a)discussions.microsoft.com> wrote in message
news:F393179C-2AB5-4807-BDE5-98D696361860(a)microsoft.com...
> 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,
>
>
>

From: Rohinikumar on 25 Feb 2010 07:43
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,
>
>
>
From: Rohinikumar on 25 Feb 2010 07:47
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,
>
>
>
 | 
Pages: 1
Prev: How do i change a digit into word i,e 1 = one
Next: Excel 2007 Macro/VB Question DDE Question