# Looking for a formula to help with a point scoring system

Copper Contributor

# 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?

2 Replies

# Re: Looking for a formula to help with a point scoring system

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.

# Re: Looking for a formula to help with a point scoring system

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!