Formula help look up part of string value

[ks1102]

Dear All & experts

which formula can help to count range if content "like USA" form Range "A2 to A230" :

the Value look like variance in cell ! but some were there would have "USA" wording inside .

want cont number of it at the range "B1"

thanks you help

[mdimran.ahmed30]

Hi,

Can you attach sample excel file for the same.

Imran.

[MarvinP]

Hi ks,

In B1 put this formula.

=COUNTIF(A2:A230,"*USA*")

[ks1102]

Dear Imran
the range lookup like that

[ks1102]

Thanks you advice