Forum Discussion
trying to add values from a formula from a test
I have a test with a series of yes no maybe answers yes = 10 maybe= 5 no= 0 then i need to add the numeric value up from certain questions ie: q 2 ,5, 7 ,& 10= the sum of the values q3,...
I have no chance of testing this formula right now because I’m replying via mobile phone but perhaps this will give you an idea:
Assuming the answers “Yes”, “Maybe”, and “No” are in Column A, and they are weighted as 10, 5, and 0, respectively, you can obtain the weighted sum with this formula:
=SUMPRODUCT(((A:A=“Yes”)*10)+((A:A=“Maybe”)*5)))
Assuming the answers “Yes”, “Maybe”, and “No” are in Column A, and they are weighted as 10, 5, and 0, respectively, you can obtain the weighted sum with this formula:
=SUMPRODUCT(((A:A=“Yes”)*10)+((A:A=“Maybe”)*5)))