Assistance Needed With Determining Which Functions To Use!

[ninja_turtle]

Good Afternoon All,

I generally have been able to learn a lot from this forum and get all my questions answered just from reading other threads. However I am stuck and wanted to see if the community can help me out!

Here's a quick and dirty example of my worksheet:

Columns A - E contains lists of names:

	A	B	C	D	E
1	joe	tim	bill	joe	luke
2	james	lee	bob	bob	roger
3	tim	luke	mark	kevin	ike
4	ike	bob	roger	tim	joe
5	kevin	james	joe	scott	mike

<tbody>
</tbody>

Elsewhere in my worksheet, I've used a formula to pull all of the names contained anywhere in Columns A - E and it looks like this:

	H	I	J	K	L	M	N
1		joe	tim	bob	mike	roger	kevin
2	joe
3	tim
4	bob
5	mike
6	roger
7	kevin

<tbody>
</tbody>

What I want my formula to do is, in cell J2, count how many columns (A - E) contain BOTH the names "tim" and "joe" . So it would return a number from 0 - 5. And in cell M4 it will count how many columns "roger" and "bob" both appear in, and so on.

I won't waste any more time trying to explain what functions I've tried with no success. Hopefully my example is clear enough. Thanks in advance for any help!