I need to find a fair way to select our next comp team based on the results from the previous comp. I have added all of the scores for the individual events and overall results. However I would like to select the team based on how many points each player has been awarded based on the 1st, 2nd, 3rd, etc table for each individual event. I need the "Points Column" to add up the points awarded from the table below the main spreadsheet but have no idea where to start. Any help would be greatly appreciated.
Bookmarks