Improve a formula by searching for a text string rather than individual words

[Badvgood]

Can anyone help improve my formula?

=IF($Q$1="TYRE",SUM(COUNTIFS(SOCo,$O2,RTS_code,{"TYREL","TYRE","TYR","TTYR","HTYRE"})),COUNTIFS(SOCo,$A28,RTS_code,IF(AND($Q$1="AIRCON",$O2="03"),"BAIR",$Q$1)))

I would like to improve it by revising the section in bold.

If possible, rather than search for the specific text "TYREL" or "TYRE" Etc, I would like it to find all occurrences where the letters "TYR" areas this is the common denominator in all the text strings, either at the beginning, middle or end.

My concern is, for example, that text such as "PTYRE" could get added and my current formula would not include this in the results.

Thanks in advance.

[Rick Rothstein]

Since COUNTIF can use wildcards, I think this would count any cell containing the letters TYR next to each other (just change YourRange to your actual range reference)...

COUNTIF(YourRange,"*TYR*")

[Badvgood]

Since COUNTIF can use wildcards, I think this would count any cell containing the letters TYR next to each other (just change YourRange to your actual range reference)...

COUNTIF(YourRange,"*TYR*")

Perfect, thank you.