Hello all! I am a teacher and I am trying to calculate what each student
scored on a test. Here's my setup:

Column A Column B C D
E
Question1 Question2 Question 3
Question 25

Correct Answer: A D A
C

John Bratty C D A
B
Willy Wonka D A D
C
Jenny Penny A B A
C

I used COUNTIF to determine what the class scored on each question, but how
can I tell what each student scored on the test? please help. I am using
Excel 2007.