• 395K Members
• 7,187 Online
• 428K Conversations

trying to add values from a formula from a test

Occasional Visitor

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

2 Replies

Re: trying to add values from a formula from a test

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

Re: trying to add values from a formula from a test

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.

Related Conversations