| Game | Win | Draw1 | Draw2 | Loss | Win Goals | Draw1 Goals | Draw2 Goals | Loss Goals |
| 1 | Calum | Steve | 3 | 3 | ||||
| 1 | Owen | James | 1 | 0 | ||||
| 1 | Jim | Victoria | 2 | 1 | ||||
| 1 | Peter | 0 | ||||||
| 1 | ||||||||
| 1 | ||||||||
| 1 | ||||||||
| 2 | Calum | Dan | 4 | 5 | ||||
| 2 | James | Steve | 4 | 5 | ||||
| 2 | Phil | Tom P | 1 | 1 | ||||
| 2 | Tom G | Dave | 2 | 0 | ||||
| 2 | ||||||||
| 2 | ||||||||
| 2 | ||||||||
| 3 | Dan | Calum | 2 | 1 | ||||
| 3 | Peter | Owen | 2 | 1 | ||||
| 3 | Tom G | Jim | 1 | 1 | ||||
| 3 | Phil | Dave | 0 | 1 | ||||
| 3 | Steve | Tom P | 2 | 2 | ||||
| 3 | ||||||||
| 3 |
<tbody>
</tbody>
This is for teams put together in a given game.
I have a table that looks like above where it goes down 100s of rows, i have fixed groups of 7 rows. I want a way to count the number of times 2 names are listed on the same team together in a group. Ive been trying using something like this:
=SUM(IF(COUNTIF($R$10:$R$16,$AC48)+COUNTIF($R$10:$R$16,AD$2)=2,1,0),IF(COUNTIF($Q$10:$Q$16,$AC48)+COUNTIF($Q$10:$Q$16,AD$2)=2,1),IF(COUNTIF($S$10:$S$16,$AC48)+COUNTIF($S$10:$S$16,AD$2)=2,1,0),IF(COUNTIF($P$10:$P$16,$AC48)+COUNTIF($P$10:$P$16,AD$2)=2,1,0),IF(COUNTIF($R$3:$R$9,$AC48)+COUNTIF($R$3:$R$9,AD$2)=2,1,0),IF(COUNTIF($Q$3:$Q$9,$AC48)+COUNTIF($Q$3:$Q$9,AD$2)=2,1),IF(COUNTIF($S$3:$S$9,$AC48)+COUNTIF($S$3:$S$9,AD$2)=2,1,0),IF(COUNTIF($P$3:$P$9,$AC48)+COUNTIF($P$3:$P$9,AD$2)=2,1,0))
This works for the first 2 rows, id like to be able to have an output table showing the number of times people were together that looks like this:
| Calum | Owen | Jim | Dave | |
| Calum | - | 2 | 2 | 1 |
| Owen | 2 | - | 2 | 1 |
| Jim | 2 | 2 | - | 1 |
| Dave | 1 | 1 | 1 | - |
<tbody>
</tbody>
Ive been struggling to make something simple. Looking to use a loop that can apply in a series of equal sized arrays
Thanks in advance
Owen3001
