Hi Group,

I am looking for a function which will count occurence of part of text
in a cell in one column.

For example cell contains My finance loans and the columns conatins
many combination of loans I want to count how many times the "loans"
string occurs

Note: Without using data filter option.

Thanks
Shirish

Try...

=COUNTIF(A1:A10,"*loans*")

or

=COUNTIF(A1:A10,"*"&B1&"*")

....where B1 contains the criteria, such as 'loans'.

Hope this helps!

In article om,
wrote:

Hi Group,

I am looking for a function which will count occurence of part of text
in a cell in one column.

For example cell contains My finance loans and the columns conatins
many combination of loans I want to count how many times the "loans"
string occurs

Note: Without using data filter option.

Thanks
Shirish