Rookie here, please excuse my ignorance. Also, I am sure I would have found a relevant thread in the sea of knowledge here, but like in the Hitchhiker`s Guide, formulating the question (and thus researching it) is my bigger issue.

I am trying to set up a formula to find a string of text, and return a numerical value of the number of hits:

=COUNTIF('Copy Amenity VALUES Here'!A1:T200,"*$50*")

This works well, the problem is it only works when using wildcards, but then it also counts longer strings containing $50, i.e. $500, or $5000.

I have also tried:

=SUMPRODUCT(--ISNUMBER(SEARCH({"$50"}, 'Copy Amenity VALUES Here'!A1:T200))), which has the same issue.

Case sensitivity is not a problem. If I could e.g. specify the number of characters I am looking for, that could also solve the issue.

I am sure I must be missing some basic knowledge here - these functions are kind of useless if for instance "*hat*" gives a hit for the word "hate".

Any help is much appreciated.