In an excel, I am having a quiz, but complication is that each question has different options and hence difference score. So each question can have one answer and based on selection, there is a score given which is different for each question options.
So for example For Question 1 – selecting A is .5, B is 1.0, C is 1.5 and so on.
and Question 2 could be A is .75, B is 0, C is .25.
This should give the idea of the complexity. I tried combination of vloopup and countif etc but not able to wrap my head around it. At the end, i just need total for all questions. e.g. Q1 – .5, Q2 – .25 = .75.
would appreciate any inputs.

​In an excel, I am having a quiz, but complication is that each question has different options and hence difference score. So each question can have one answer and based on selection, there is a score given which is different for each question options.So for example For Question 1 – selecting A is .5, B is 1.0, C is 1.5 and so on.and Question 2 could be A is .75, B is 0, C is .25.This should give the idea of the complexity. I tried combination of vloopup and countif etc but not able to wrap my head around it. At the end, i just need total for all questions. e.g. Q1 – .5, Q2 – .25 = .75.would appreciate any inputs.  Read More

​