compare results
 

In a soccer tournament predications are made by individuals of the score for
each game. Points are awarded to each individuals accuracy in predicting the
outcome of each game using: correct score in the game- 3 points; correct
result (i.e.prediction of a home or away win regardless of score) - 1 point;
any other result - 0 points. The most points that can be awarded in any
prediction is therefore 3. Does anyone have a spreadsheet or formula that can
show this on a spreadsheet. I have about 40 forms to check from individuals -
I know Excel can do this!