Forum Discussion
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,...
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.