On Feb 24, 10:26 am, Jenai wrote:
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.

=SUMPRODUCT(--(B2:Z2=$B$1:$Z$1))

assuming John Bratty's answers are in row 2 and the correct answers
are in row 1 and that there are 25 question.
Fill down to return other student's marks.

Ken Johnson