Me and my colleague bet football games, it looks like in the picture attached.

Our rules are simple:

- correct score = 3 points
- Someone guess the winner but with no correct score: 1 points
- No guess: 0 points

What I've figured out so far is how to add 3 points for a correct score:

Code:

`=IF(AND(D4=G4,E4=H4),3,0)`

The sum of all points would be located in cell G6 and I6 respectively.

I'm not sure how to modify the IF formula to include 1 and 0 points awards.

Any help would be appreciated.

Regards,

Sojek