May 29 2019 10:17 AM
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?
May 29 2019 10:40 AM
May 29 2019 10:52 AM
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.