In a single cell, count any occurrences from a list of values

Title basically explains it all. I've tried to figure this out on my own but can't seem to find anything that works.

First, I have a list of static values in a range I've named "friends":

Brad
George
Jacob


Elsewhere, I have cells which contain the following (each line of text would be in a single cell):

Brad and george went to the store
jacob jacob anderson jeff
help me obibradkenobi you're my only hope
333 jessica brad george brad

For each of those above cells, I want to know how many times any of the values in "friends" appears in that cell. (It should not be case sensitive) So the results should be:

2
2
1
3

Thanks!

daedelous00,

Something like this should work for you:

Please Login or Register  to view this content.

cheal2,

A few flaws with that formula:
It doesn't used the named range, and it checks each cell individually. If his named range friends contains 10, or 20, or more cells, that is a lot of manual typing the formula and it will not scale well.
FIND is case sensitive, so in his list, the names have the first letter capitalized but the the sentences are all lower case, so the FIND function will not find them. This can be gotten around either by coupling the FIND function with the LOWER (or UPPER) function, or by using the SEARCH function instead (SEARCH does the same thing as FIND, but it is not case sensitive).
Lastly, if a name appears in a sentence more than once, it will still only be counted once, which would yield incorrect results given the fourth example sentence where "brad" appears twice.

You're very welcome