Excel help with formulaes to produce appearance records for weekly football logs

[owen3001]

Hey i log information for my weekly work football and am trying to automate more of my collection of data. I have a set of data that looks like this:

Date Game No. Win Draw1 Draw2 Loss Win Goals Draw1 Goals Draw2 Goals Loss Goals Win Scorer Draw1 Scorer Draw2 Scorer Loss Scorer 9 Jan 1 James Todd 5 1 3 0 1 Pete Jay 5 1 0 1 1 Colin Rich 5 1 1 0 1 Elliot Nick 5 1 1 0 1 1 1 16 jan 2 James Pete 7 7 3 2 2 Colin Elliot 7 7 2 2 2 Pat Jay 7 7 1 2 2 Rich Nick 7 7 1 1 2 2 2 23 jan 3 Elliot James 3 1 2 1 3 Nick Pete 3 1 1 0 3 Pat Colin 3 1 0 0 3 Jay Baz 3 1 0 0 3 3 <tbody> </tbody> I have a formulae that will tell me how often 2 players play together, (will show example below) but i dont know how to adapt it to be able to say how many times 2 people attended a session. I would like a similar table as below Formulae used: =IF($AP3=AR$2," ",SUM(IF($U$3:$X$233=$AP3,COUNTIFS($T$3:$T$233,$T$3:$T$233,OFFSET($U$3:$X$233,,COLUMN($U$3:$X$233)-MIN(COLUMN($U$3:$X$233)),,1),AR$2)))) Games on same Team Jay Nick Pete Colin Jay - 3 1 0 Nick 3 - 1 0 Pete 1 1 - 2 Colin 0 0 2 - <tbody> </tbody>

<tbody>
</tbody>

Below is the table id like to be auto generated, only used subset of players so not evenyone plays the same number of games. I want this so i can calculate the percentage of time people are on same team.

Games Appear together	Jay	Nick	Pete	Colin
Jay	-	3	3	3
Nick	3	-	3	3
Pete	3	3	-	3
Colin	3	3	3	-

<tbody>
</tbody>

Thanks for any assistance.