Prev: Embedded lookup
Next: Two Condition - search
From: Rock on 24 May 2010 14:42
I am using this formula to count the number of rows in Column C with text.

=SUMPRODUCT(((LEN(C4:C500)=4)+0)*(ISTEXT(C4:C500)))

I need, instead, for this formula to count the number of rows in Column C
with specific text i.e. the text “PUSH”. Can you help?

From: Dave Peterson on 24 May 2010 15:02
=countif(c:c,"push")
will count the number of cells in column C that have push in them.


Rock wrote:
>
> I am using this formula to count the number of rows in Column C with text.
>
> =SUMPRODUCT(((LEN(C4:C500)=4)+0)*(ISTEXT(C4:C500)))
>
> I need, instead, for this formula to count the number of rows in Column C
> with specific text i.e. the text “PUSH”. Can you help?

--

Dave Peterson
From: Rock on 24 May 2010 15:46
This is absolutely perfect! Thank you.

"Dave Peterson" wrote:

> =countif(c:c,"push")
> will count the number of cells in column C that have push in them.
>
>
> Rock wrote:
> >
> > I am using this formula to count the number of rows in Column C with text.
> >
> > =SUMPRODUCT(((LEN(C4:C500)=4)+0)*(ISTEXT(C4:C500)))
> >
> > I need, instead, for this formula to count the number of rows in Column C
> > with specific text i.e. the text “PUSH”. Can you help?
>
> --
>
> Dave Peterson
> .
>
 | 
Pages: 1
Prev: Embedded lookup
Next: Two Condition - search