 • 446K Members
• 10.5K Online
• 537K Conversations

# 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
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies