Hi,

how to count number of "partial string" in a range of column

for ex: column E contains text as "Pass", "pass on 20/01/08", "issue Passed
on "21", "fail".

now, i wanted the count which searches the cell values that contains the
word "pass" (case insensitive)".

here, in this case the count is 3 (answer).

how to do it?

I tried COUNTA and DCOUNTA. it didnt work

Thanks,
Venkat

With wildcards:

=COUNTIF(E1:E100,"*pass*")

--
Gary''s Student - gsnu200826


"Venkatesh V" wrote:

> Hi,
>
> how to count number of "partial string" in a range of column
>
> for ex: column E contains text as "Pass", "pass on 20/01/08", "issue Passed
> on "21", "fail".
>
> now, i wanted the count which searches the cell values that contains the
> word "pass" (case insensitive)".
>
> here, in this case the count is 3 (answer).
>
> how to do it?
>
> I tried COUNTA and DCOUNTA. it didnt work
>
> Thanks,
> Venkat

Thanks a lot. it worked

"Gary''s Student" wrote:

> With wildcards:
>
> =COUNTIF(E1:E100,"*pass*")
>
> --
> Gary''s Student - gsnu200826
>
>
> "Venkatesh V" wrote:
>
> > Hi,
> >
> > how to count number of "partial string" in a range of column
> >
> > for ex: column E contains text as "Pass", "pass on 20/01/08", "issue Passed
> > on "21", "fail".
> >
> > now, i wanted the count which searches the cell values that contains the
> > word "pass" (case insensitive)".
> >
> > here, in this case the count is 3 (answer).
> >
> > how to do it?
> >
> > I tried COUNTA and DCOUNTA. it didnt work
> >
> > Thanks,
> > Venkat