I have a list of teams with a list of players next to it
(Would it be better/easier if the players are in a single cell?)
+Team Name+--------+--------+
| Team 1 |Player 1|Player 2|
| Team 2 |Player 3|Player 4|
| Team 3 |Player 1|Player 3|
| Team 4 |Player 2|Player 4|
+---------+--------+--------+
Then I have a list of games with what team played against what team and who won
+------+------+------+--WON-+
|Game 1|Team 1|Team 2|Team 1|
|Game 2|Team 3|Team 4|Team 4|
+------+------+------+------+
I'd like count how many times a specific player has won and how many times he has played
+--------+#wins+#plays+
|Player 1| 1 | 2 |
|Player 2| 2 | 2 |
|Player 3| 0 | 2 |
|Player 4| 2 | 2 |
+--------+-----+------+
List of teams Specific player
v v
Using =COUNTIF(H2:U999; A2)
does not work if a team composition is reoccurring
I don't know if it's matters but it's a online google spreadsheet