COUNTIF not exact match

Column "G" contains a list of names most of which are more than one word. The formula

Please Login or Register  to view this content.

works if H9 contains an exact match. I am looking to be able to find all instances of a word in the list, ie. if the list contains cells with team red and another cell contains team green, I want to find all instances of red or green by entering the word red or green in cell "H9".


Thanks
Jim O