Hello,
I am running a 2004 Excel on my Mac. I have a large list of people and corresponding answers (A, B, C, D, and E) from a test each person took (all the same test).

I have the solutions to the test. I want to create a worksheet that will assign a +1 point for each correct value, and 0 points for an incorrect value, and then I want to tally the total for each ID.

How would I go about setting this up? I'm thinking an if/else, but can't figure out the correct way to do this. Any help is greatly appreciated.

Thanks.