trying to add values from a formula from a test

Copper Contributor

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, 4, 8,9  = sum of those questions

 

but it seems i cant add the values it is add the formula   how do i add the answers up?

    

 

2 Replies
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)))

@LifeCoach_SGF 

First remove the double quotes around the numbers in the formula in E3. Copy the formula down.

Then use some helper cells C89:C94 and fill them with the appropriate values: C, U, S, L, G and D.

And last: this formula in D89:

=SUMIFS($E$3:$E$86,$F$3:$F$86,C89)

And copy the formula down.