Quote:
Originally Posted by J. Gary Ellison
Here's what I'm trying to do:
1 Test Question 1 2 3 4 5 6 ...
2 Answers Key A C A B D B ... # of Right Answers
3 Student 1 A D A B D C ... 4 (Formula would go here to compare current row)
4 Student 2 A C A B D D ... 5 (with Answer Key row & count the right answers)
....
How do count the right answers by comparing the answers from each student with the Answer Key in row 2. I want to be able to score the tests by entering in the answers.
|
-------------------------
=IF(LOOKUP(ROW(A1),$A$2:$A$16,$B$2:$B$16)=C2,"Corr ect","Incorrect")
Assuming:
Question number is mentioned in A2:a16
Correct answer is mentioned in b2:b16
Student 1 answer is mentioned in D2:d16
Then,
Paste this formula in cell e2