How to add points when the answer is correct?

[jkskates]

My apologies if this question has already been asked/answered and thanks in advance for any help.

I've set up a spreadsheet for the 2012-2013 college football bowl season. I've had excel randomly add a point value(1-4 and 5 for championship game) to each game. I've also created a drop down list for the participant to pick who they think is going to win and a list for the moderator to add the winner.

Q: Is there a way to have excel count the point value if the participant correctly chooses the winner?

I've attached a copy of what I currently have, thanks.

[abo.osama]

hi
hopefully that's what you're looking for
check attached file

[protonLeah]

I used named ranges and offsets in the formula below to make copy and pasting to the remaining columns easier.

Please Login or Register  to view this content.

Copy the entire points awarded column then paste to remaining PA columns

[jkskates]

Worked! Thanks so much for help!