How to grade a test with different points by answer in Excel?

I'm trying to do something similar than this: https://exceljet.net/formula/score-quiz-answers-with-key

But it is not the same because I have different "points" for each question.

For example, correct answer for question 1 gives you 2 points, but correct answer for question 10 gives you 6 points.

I need to get the total of points for each student based on their answers and how many points each answer gives them.

This is the sheet with the answers and points:

https://stackoverflow.com/questions/66926338/how-to-grade-a-test-with-different-points-by-answer-in-excel April 03, 2021 at 07:26AM