software

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 quot;loansquot;
string occurs

Note: Without using data filter option.

Thanks
ShirishTry...

=COUNTIF(A1:A10,quot;*loans*quot;)

or

=COUNTIF(A1:A10,quot;*quot;amp;B1amp;quot;*quot;)

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

Hope this helps!

In article omgt;,wrote:

gt; Hi Group,
gt;
gt; I am looking for a function which will count occurence of part of text
gt; in a cell in one column.
gt;
gt; For example cell contains My finance loans and the columns conatins
gt; many combination of loans I want to count how many times the quot;loansquot;
gt; string occurs
gt;
gt; Note: Without using data filter option.
gt;
gt; Thanks
gt; Shirish