Looking for a Function which counts the repeatition of text in a column

S

shirish

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
 
D

Domenic

Try...

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

or

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

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

Hope this helps!
 
Top