League Table - Point Scoring

[blairduncan1]

Hi, I am running a Euro 2020 predictor for my local football club and have around 40 entries.
The scoring is based on 5 points for a correct score and 2 for a correct result, same as Sky’s Super 6.

Looking for recommendations on how best to tabulate this and make a formula so I just need to input the predictions and then input the actual scores and excel will take care of the rest.

[JohnTopley]

You have (almost) defined the format from your description

Column Headings

Name , Predicted Score, Actual Score, Points Scored

Add team details if required and think about hove record scores to make calculation easy.

[JohnTopley]

This is a current thread which appears to have similar requirements to yours so you may be able to use this as a "model":

https://www.excelforum.com/excel-for...es-a-week.html