Thanks for the reply Chemist, but no, this wouldn't help.

I want the COUNTIF to count ANY of the terms in the second block. (i.e. it would scan the top block for any of Horse Bear Red Blue Dog, and provide the count of the matching values)

Second, I want it to only count a matching value ONCE. For example, "Bear" appears on the top block twice, but I only want it to count ONCE if it matches. In other words, I only want unique matching values.

Does that make sense?