How to count the occurrence of particular text within a text string in an array

[Santanu Chatterjee]

Dear All,

I have a data where in a particular column I need to count the occurrence of a string "Not Interested" which may or may not be a part of a larger string based on another criteria of date. I have applied the countifs but it is unable to find the string and count its occurrence. Could anyone help me with a formula that will get me the count?

Regards,
Santanu

 

[shrivallabha]

How are you applying COUNTIF to the column?
=COUNTIF(A1:A100,"*not interested*")
Above formula worked for me.

 

[Santanu Chatterjee]

Thanks....it worked ....I was not aware about the application of asterix

 

[shrivallabha]

Thanks....it worked ....I was not aware about the application of asterix

Good. Asterix acts as wildcard.

 

[Felix]

=COUNTIF(A1:A100,"*cabinet*").
Thanks, this formula worked for me also. Now please take a look at my SS, and help me have my results added up. My result should be 3 instead of two because I want those raws in B6:B8 that match the "countif" to be added up. Is it possible?
Thanks again

 

[Felix]

Guys, I am sorry if I took a little of your time. YOU ARE AWSOME!!! I founf my answer in another post in Which HUI helped. This is what I did:
=SUMIF($E$12:$K$39,"*CABINET*",$B$12:$B$39)