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