SOLVED

What formula

Copper Contributor

Ive been tasked with determining who the top 8 riders are in points. I have the spreadsheet with the points from the season, but I do not how how to create a formula to find the total overall points a rider has because some have riden in multiple divisions.  Anyone able to help? 

1 Reply
best response confirmed by momtomari (Copper Contributor)
Solution

@momtomari You would want to put all the results in on single table with three columns (Division, Rider, Total Points). No empty rows or columns. Then you can create a pivot table  and sort it as you like. The attached workbook contains an example in the tab "Data and PT".

1 best response

Accepted Solutions
best response confirmed by momtomari (Copper Contributor)
Solution

@momtomari You would want to put all the results in on single table with three columns (Division, Rider, Total Points). No empty rows or columns. Then you can create a pivot table  and sort it as you like. The attached workbook contains an example in the tab "Data and PT".

View solution in original post