Help with Formula to count game points
Hi, I’m a soccer mum with little excel smarts. I’m collecting each game from the team who were the top 3 players for the game and assigning them 3 points for best, 2 points for 2nd best and 1 point for 3rd best. At the end of the season this goes towards awards.
I have set up a table with drop down boxes and I ask each girl who they are allocating the 3 pints to, the 2 pints to and the 1 point.
What I need now is a way to calculate the points each player got each game.
This is what I’m stuck figuring out.
If I can figure this out I can apply this formula to all the subsequent games.
Hi, I’m a soccer mum with little excel smarts. I’m collecting each game from the team who were the top 3 players for the game and assigning them 3 points for best, 2 points for 2nd best and 1 point for 3rd best. At the end of the season this goes towards awards. I have set up a table with drop down boxes and I ask each girl who they are allocating the 3 pints to, the 2 pints to and the 1 point. What I need now is a way to calculate the points each player got each game.This is what I’m stuck figuring out.If I can figure this out I can apply this formula to all the subsequent games. Read More