Point-betting sheet

I want to create an excel sheet for a point system betting for the world cup.

I don't mind doing the research for this, but can anyone guide me as to what I should be looking into?

Here is the scenario:

Contestants submit exact scores for games.

1 point is given for predicting the correct outright outcome (Win/Draw/Win).
1 point is given for predicting the exact score.

2 extra points are rewarded if the outright prediction is unique.
1 point if the outright score was predicted by two people.
0 points if three or more predicted the same outright score.

1 extra point is rewarded if the exact score is unique.
0 points if two or more people predicted the same exact score.

Summary:
Predict outright 1-3 points
Predict exact score 1-2 point

5 points can be possibly earnt per game


-----
Thanks

Hi,

Maybe something like the attached

Regards

Hi,

Is the attached any better?

If not add some extra columns to show what result you expect and upload it. It's just a matter of playing around with the IF() and COUNTIF() functions.

I was somewhat confused by what you mean by outright prediction and outright score.

Regards