premiership football prediction system, need help with the coding to check results

[monkeybouy]

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

[JBeaucaire]

Hi monkeybuoy. Click GO ADVANCED and use the paperclip icon to post up your workbook.

Make sure you not only have good sample data already in the workbook, but mockup samples of the desired results in column P, too. Make sure it's clear to see on the sheet what you want.

[monkeybouy]

thanks will do in the next five mins

[daddylonglegs]

Assuming C2:I2 and C54:I54 all have numbers 1, 2 or 3 then try this formula in P2

=SUMPRODUCT((C2:I2=C$54:I$54)*(C2:I2<>""))

[monkeybouy]

thanks alot daddy , that seems to work amazingly, you are a star