What formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2991467%22%20slang%3D%22en-US%22%3EWhat%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2991467%22%20slang%3D%22en-US%22%3E%3CP%3EIve%20been%20tasked%20with%20determining%20who%20the%20top%208%20riders%20are%20in%20points.%20I%20have%20the%20spreadsheet%20with%20the%20points%20from%20the%20season%2C%20but%20I%20do%20not%20how%20how%20to%20create%20a%20formula%20to%20find%20the%20total%20overall%20points%20a%20rider%20has%20because%20some%20have%20riden%20in%20multiple%20divisions.%26nbsp%3B%20Anyone%20able%20to%20help%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2991467%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2991710%22%20slang%3D%22en-US%22%3ERe%3A%20What%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2991710%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1225800%22%20target%3D%22_blank%22%3E%40momtomari%3C%2FA%3E%26nbsp%3BYou%20would%20want%20to%20put%20all%20the%20results%20in%20on%20single%20table%20with%20three%20columns%20(Division%2C%20Rider%2C%20Total%20Points).%20No%20empty%20rows%20or%20columns.%20Then%20you%20can%20create%20a%20pivot%20table%20%26nbsp%3Band%20sort%20it%20as%20you%20like.%20The%20attached%20workbook%20contains%20an%20example%20in%20the%20tab%20%22Data%20and%20PT%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

@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".