Is there a formula to highlight and/or count the number of team deals.
Ideally, I'd like to count the number of team deals so I can put it into a
table and graph the results. Here are the parameters:

Team A consists of the following members: John, Joe, Bob
Team B consists of the following members: Shannon, Susan, Sally

A B
1 John Susan
2 Joe Sally
3 Bob John
4 Susan Shannon
5 Sally Bob
6 Sally Shannon

I need a formula that will count Team A Deals (row 3) and Team B Deals (row
4/6) with the following results.

Team A Deals = 1
Team B Deals = 2

Help!!! Thanks in advance... you guys are the BEST!