Forum Discussion

LifeCoach_SGF's avatar
LifeCoach_SGF
Copper Contributor
May 29, 2019

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

 

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

    

 

excel
Formulas and Functions

2 Replies

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    May 29, 2019

    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.

     

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    May 29, 2019
    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)))

Resources