How to find all unique, matching values betwen two arrays of cells

I really need help!

I currently have a spreadsheet that is laid out with two blocks of text like so:

Brick Bat Bear Pen Compass
Red Blue Yellow Fish Hen
Pig Pig Bear Fish Brick
Compass Bat Pen Fish Brick


Horse Bear Red Blue Dog

I want to find the number of UNIQUE values in the first, big block of text that MATCH with the second small block of text. That is to say, if for instance "Red" matches with the block above 2 times, I want it to count once. If "Horse" matches 0 times, I want it to count as zero.

I've tried everything! How would I set this function up?

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?

Yes! This is actually perfect.

However, I want run a count if using ALL the words in the bottom block at once. Is there anyway I can apply this formula, to search for all the words in the bottom block at one time?

Ah yeah, I found that way too, but I was hoping for find a method without inputting every single cell.

Thanks for the attempt Chemist.

If anyone else has any ideas, I'd be happy to hear them

You're a genius man...

Thank you so much

out of curiosity, what do the two little dashes in the parentheses before COUNTIF do?