Forum Discussion
Looking for a formula to help with a point scoring system
I've been asked to create a spreadsheet that helps track members race predictions and a point scoring system on race outcomes for a league table. There are six races in a day and the league members make a singular prediction on who will place in either 1st, 2nd or 3rd in each race.
I have league members names in column A (A6 to A14),
Race times in Columns B,D,F,H etc
Their predictions are input across the corresponding rows in alternate cells B6, D6, F6, H6...etc and in cells C6, E6, G6, I6 etc I want to add what points they have gained if they made a correct prediction. If they didn't make a correct prediction the cell should equal 0 points.
The results of each race sit in the following cells: B16, B17, B18. With points results in C16, C17 & C18 etc. First place = 3points. Second = 2pt, Third place = 1pts
Is there a formula that can help me with this or will I need to input points gained for each race manually?
Many thanks in advance!
Hello McEwanOwn54
I think you can solve your problem using the SUMPRODUCT() Function. I have created an example for you. I hope I have understood your problem.
If you enter the predictions in cells B6:B14 separated by commas, the points will be calculated in C6:C16.
Have a look at my example to see if it comes close to your task. You may then be able to make your task more precise.
Hello dscheikey
This has worked perfectly!! Thank you so much. I really thought it was going to be an awkward task. You are a star and have saved me so much time banging my head against a wall.
Wishing you a wonderful day filled with goodness!
