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:

[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]joe[/TD]
[TD]tim[/TD]
[TD]bill[/TD]
[TD]joe[/TD]
[TD]luke[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]james[/TD]
[TD]lee[/TD]
[TD]bob[/TD]
[TD]bob[/TD]
[TD]roger[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]tim[/TD]
[TD]luke[/TD]
[TD]mark[/TD]
[TD]kevin[/TD]
[TD]ike[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]ike[/TD]
[TD]bob[/TD]
[TD]roger[/TD]
[TD]tim[/TD]
[TD]joe[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]kevin[/TD]
[TD]james[/TD]
[TD]joe[/TD]
[TD]scott[/TD]
[TD]mike[/TD]
[/TR]
</tbody>[/TABLE]










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:

[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD][/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]joe[/TD]
[TD]tim[/TD]
[TD]bob[/TD]
[TD]mike[/TD]
[TD]roger[/TD]
[TD]kevin[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]joe[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]tim[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]bob[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]mike[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]roger[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]kevin[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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!