I have a sheet which tracks a league table of players, and assigns points to each individual based on individual games and the number of players in each game. The point score for the winner is always the number of players squared, so a 5 player game =25 points, a 4 player game is 16 pts etc,. Each position below the first scores 1 multiple less, so in a 5 player game, 2nd place is worth 20 pts, 3rd is 15, etc in a 4 player 2nd is 12, 3rd is 8 etc,. Any individual that didn't play also scores points, equal to roughly the average in that game, eg 14 pts in a 5 player game. The points are tallied to create a graph and league position. All the user needs to do is enter the names of the players in position order and the code does the rest.

So far so good. I have a working sheet that does the job but I feel it's inelegant and that there could be a better way. I have an index function that checks the line of players and finds out what position they were in and assigns a score (based on the above amounts), if the Index doesn't find a match, an IFERROR scores the amount for not playing. The thing is I'm having to run this calculation for every player (of which there are 25+) in every game to get their point score and then SUMing all the point scores to get a total. I keep thinking a SUMIF could be used, but I cant figure out how to capture everything I need.

2017 WIP.xlsx
Above is one sheet from my workbook. If you scroll off the page to the right, you will see all the columns for each player and all the INDEX match functions.