Hi! I play games with my friends and for fun we're tracking how many wins each person has, there are four of us in total but sometimes only three of us play. What I'm trying to do two things, count the total number of games where the 4 of us are present and see each persons win total. We have an excel formatted as follows
1) Question 1: Determining the total number of 4 player games. In the 5/1/2020 column we played a total number of 5 games. Mark won 1 game, Dalton won 3 games and Tory won 1 game. If someone wins multiple games each win is denoted by a comma in the corresponding cell as well as what cards they won with.
What I need to do is check how many players played that day and then sum total number of games played on days with 4 players. In the example above it would be 9. Five games on 5/1 and four games on 5/3.
2) Question 2: Determining the total number of games won by each person where 4 players are present. Very similar to above but just filtering for the player as well.
answer for Mark would be 5, Dalton 4, Tory 3 and Matt 1.
Any help is much appreciated.
Thank you!
Date of match | 5/1/2020 | 5/2/2020 | 5/3/2020 | 5/4/2020 |
# of player | 4 | 3 | 4 | 3 |
Mark | Liesa | Liesa | Liesa, Yarok | Krark |
Dalton | Nekusar, Nekusar, Gismold | Elenda | Grismold | |
Tory | Gishath | Nekusar | Marchesa | |
Matt | Marisi |
1) Question 1: Determining the total number of 4 player games. In the 5/1/2020 column we played a total number of 5 games. Mark won 1 game, Dalton won 3 games and Tory won 1 game. If someone wins multiple games each win is denoted by a comma in the corresponding cell as well as what cards they won with.
What I need to do is check how many players played that day and then sum total number of games played on days with 4 players. In the example above it would be 9. Five games on 5/1 and four games on 5/3.
2) Question 2: Determining the total number of games won by each person where 4 players are present. Very similar to above but just filtering for the player as well.
answer for Mark would be 5, Dalton 4, Tory 3 and Matt 1.
Any help is much appreciated.
Thank you!