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 ...
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!