Home

trying to add values from a formula from a test

%3CLINGO-SUB%20id%3D%22lingo-sub-655966%22%20slang%3D%22en-US%22%3Etrying%20to%20add%20values%20from%20a%20formula%20from%20a%20test%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-655966%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20test%20with%20a%20series%20of%20yes%20no%20maybe%20answers%26nbsp%3B%20yes%20%3D%2010%20maybe%3D%205%20no%3D%200%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3Ethen%20i%20need%20to%20add%20the%20numeric%20value%20up%20from%20certain%20questions%26nbsp%3B%3C%2FP%3E%3CP%3Eie%3A%26nbsp%3B%20q%202%20%2C5%2C%207%20%2C%26amp%3B%2010%3D%26nbsp%3B%20the%20sum%20of%20the%20values%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Bq3%2C%204%2C%208%2C9%26nbsp%3B%20%3D%20sum%20of%20those%20questions%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20it%20seems%20i%20cant%20add%20the%20values%20it%20is%20add%20the%20formula%26nbsp%3B%20%26nbsp%3Bhow%20do%20i%20add%20the%20answers%20up%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-655966%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-656029%22%20slang%3D%22en-US%22%3ERe%3A%20trying%20to%20add%20values%20from%20a%20formula%20from%20a%20test%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-656029%22%20slang%3D%22en-US%22%3EI%20have%20no%20chance%20of%20testing%20this%20formula%20right%20now%20because%20I%E2%80%99m%20replying%20via%20mobile%20phone%20but%20perhaps%20this%20will%20give%20you%20an%20idea%3A%3CBR%20%2F%3EAssuming%20the%20answers%20%E2%80%9CYes%E2%80%9D%2C%20%E2%80%9CMaybe%E2%80%9D%2C%20and%20%E2%80%9CNo%E2%80%9D%20are%20in%20Column%20A%2C%20and%20they%20are%20weighted%20as%2010%2C%205%2C%20and%200%2C%20respectively%2C%20you%20can%20obtain%20the%20weighted%20sum%20with%20this%20formula%3A%3CBR%20%2F%3E%3DSUMPRODUCT(((A%3AA%3D%E2%80%9CYes%E2%80%9D)*10)%2B((A%3AA%3D%E2%80%9CMaybe%E2%80%9D)*5)))%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-656076%22%20slang%3D%22en-US%22%3ERe%3A%20trying%20to%20add%20values%20from%20a%20formula%20from%20a%20test%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-656076%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F351389%22%20target%3D%22_blank%22%3E%40LifeCoach_SGF%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20remove%20the%20double%20quotes%20around%20the%20numbers%20in%20the%20formula%20in%20E3.%20Copy%20the%20formula%20down.%3C%2FP%3E%3CP%3EThen%20use%20some%20helper%20cells%20C89%3AC94%20and%20fill%20them%20with%20the%20appropriate%20values%3A%20C%2C%20U%2C%20S%2C%20L%2C%20G%20and%20D.%3C%2FP%3E%3CP%3EAnd%20last%3A%20this%20formula%20in%20D89%3A%3C%2FP%3E%3CPRE%3E%3DSUMIFS(%24E%243%3A%24E%2486%2C%24F%243%3A%24F%2486%2CC89)%3C%2FPRE%3E%3CP%3EAnd%20copy%20the%20formula%20down.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
LifeCoach_SGF
Occasional Visitor

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?

    

 

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

@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.

 

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