I need some help creating a score predictor based on the selection of certain options. I am working on a change risk score calculator that will provide me a risk score calculator based on a users selection of the various options. The score will be used to provide risk ranges. I have attached the spreadsheet I started, Column A shows the area being evaluated, column B is the questions for each area and column C is the score that has been assigned to each answer.
What I want to see is each over score based on the variations of the options selected in a spreadsheet layout so I can evaluate the score breakdowns.