Create a point system on a forecast sheet

[fiat500]

Hi,

For the coming world cup, me and some friends have filled in our forecast in an excel file.
Al morning i am trying to find a good way for handing out points so we can have a ranking based on the score of our forecasts.

Although we are trying to keep it simple, it seems not so easy to create a score and ranking list.

The 1st Tab of the excel has the main sheet were we will put in the scores.
All other tabs are from the other participants and there forecast, the lay out is exactly the same as the main sheet.

What i want to accomplish is that i get 2 columns with a 0 or 1 as a result.
Column 1 is based on the winning team, if correct then "1", if not then "0"
Column 2 is based on the result, so if the score is for ex. 2-2 and a participant has an exact forecast, he gets a "1", anything else results in a "0".

Can anyone assist me on creating such thing that can help calculating the results?
We are with 20 people, so it would come in handy i would say

image view of the main tab: https://ibb.co/cxC6kJhttps://ibb.co/cxC6kJ


Thanks for the help guys!!

EDIT
Now with a better screen cap
https://ibb.co/iKw5ed

 

[gbell3587]

Hi

Im in the same scenario with the office sweep- can anyone help with this one?

Thanks
Graham