Formula for football (soccer) score sheet

[lamby38]

Hi All,

I'm running a sweep stake at work for the 2014 World Cup and I'm having everyone give a score prediction for every game with 3 points for the correct score and 1 point for the correct result.

I want to use excel to simplify the data entry. I'll type in everyone's predictions when they return the score sheet before the start of each phase of the tournament, then as the tournament progresses I'll enter the score from each game.

So for example;

Game 1 is Brazil v Croatia

Player A predicts 2-0
Player B predicts 1-1
Payer C predicts 3-1

If the game finished 3-1 Player A would get 1 point and Player C would get 3 points.

I'd would be great to have a formula to do this bit. (I can write, for example =If(A1=B1,A2=B2,3,0) but this doesn't account for the 1 point for a correct result, how do I add that part?

Also, can I then create a league table that would change dynamically? For example I enter the result as 3-1 and the table automatically changes to

Player C 3
Player A 1
Player B 0

I'm fairly good in excel so but any help would be excellent!!
Cheers
Chris

[micope21]

Hi

Say score in A1, B1 and prediction score in C1, D1, Next person F1, G1 so on. Cell E1

Please Login or Register  to view this content.

then copy cross H1then every 3 column and down.

Regard
micope21