Can partial text cell be found and used in CountIf formula?

[SweetScent]

Hi

Can anyone help?  I need to identify cells containing a particular string and then use COUNTIF formula to group items.  There is no standard format for the items' names,  Not sure that you can do this.  Any suggestions please.

[#2]

@SweetScent 

Yes, it can.

=COUNTIF(A1:A100,"*"&string&"*")

[#3]

Thank you.