ok guys i have set up a competition in my pub, which is like the football pools system. A person looks at the football fixtures in the premiership for the week and decided whether it will be a home win (1), draw (2) or away win (3). I have created a excel spreadsheet with the persons name and their team name and their predictions in it.

I want to make it easier on my self so i have added all the peoples details who have entered and their predictions, and at the bottom i have created a row with the correct choices. How do i create a forumla that looks at what the person has predicted and the correct decsion and then gives them a point if they have got it correct, and then adds them up at the end.

here is a example of what i have done

cell a2 has the persons name
cell b2 has the persons team name
cell c2 to l2 has the persons predicitons

cell c54 to l54 have the correct answers in it

i want to put the total for this person in the cell p2,

i assume i would need to put in a if statement but it has been a while since i have used this, can any one help,

many thanks in advance