Hi,

we're holding a world-cup betting competition in the office and i'm trying to find the easiest way to calculate the results.

There are about 35 participants, each of which have predicted the outcome of each of the first round games (based on 5 options: team1 by more than 1 goal, team 1 by 1 goal, draw, team 2 by 1 goal, team 2 by 2 goals). Hence, i have 35 columns with predictions. A typical column looks as follows:

[name Participant]
team 1 by 1 goal
draw
draw
team 2 by more than 1 goal
...

To the 35 predictions, i have added one column with the correct results.

Now, i would like to find a function that can look for each of the participants how many results are correct. In other words, for each participant, it should calculate how many predictions correspond to the correct result in the same row.

I hope you can help.

ThD.