count partial string in a range

[Venkatesh V]

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

 

[Gary''s Student]

With wildcards:

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

 

[Venkatesh V]

Thanks a lot. it worked

With wildcards:

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