Help with a formla of weighted average

%3CLINGO-SUB%20id%3D%22lingo-sub-2091878%22%20slang%3D%22en-US%22%3EHelp%20with%20a%20formla%20of%20weighted%20average%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2091878%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20kindly%20ask%20your%20help%20to%20create%20formulas%20for%20an%20evaluation%20board.%20I%20have%20an%20evaluation%20of%20criterias%2C%20which%20have%20different%20weight%20percentage.%26nbsp%3B%20How%20to%20calculate%20the%20final%20score%20of%20evaluations%2C%20according%20to%20these%20percentage%20weights%3F%3CBR%20%2F%3E%3CBR%20%2F%3EBig%20thanks%20in%20advance!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22755%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22243%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2278%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2217%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2275%22%3EPerson%20A%3C%2FTD%3E%3CTD%20width%3D%2275%22%3EPerson%20B%3C%2FTD%3E%3CTD%20width%3D%2275%22%3EPerson%20C%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECRITERIAS%20for%20group%201%3C%2FTD%3E%3CTD%20width%3D%2278%22%3EPercentage%20system%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EEvaluation%3C%2FTD%3E%3CTD%3EEvaluation%3C%2FTD%3E%3CTD%3EEvaluation%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EEvaluation%20legend%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECriterias%26nbsp%3B%20weight%3C%2FTD%3E%3CTD%3E75%25%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23FF0000%22%3Ex%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23FF0000%22%3Ex%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23FF0000%22%3Ex%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3Epoor%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECriteria%20A%3C%2FTD%3E%3CTD%3E50%25%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3Eneutral%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECriteria%20B%3C%2FTD%3E%3CTD%3E25%25%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3Egood%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECriteria%20C%3C%2FTD%3E%3CTD%3E25%25%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3Eexcellent%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECriterias%20for%20group%202%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECriterias%20weight%3C%2FTD%3E%3CTD%3E25%25%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23FF0000%22%3Ex%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23FF0000%22%3Ex%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23FF0000%22%3Ex%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECriteria%20A%3C%2FTD%3E%3CTD%3E8%25%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECriteria%20B%3C%2FTD%3E%3CTD%3E8%25%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECriteria%20C%3C%2FTD%3E%3CTD%3E9%25%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETOTAL%3C%2FTD%3E%3CTD%3E100%25%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2091878%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-2091902%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20a%20formla%20of%20weighted%20average%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2091902%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F940807%22%20target%3D%22_blank%22%3E%40HelenHi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhy%20do%20the%20weights%20for%20A%2C%20B%20and%20C%20in%20group%201%20add%20up%20to%20100%25%20while%20the%20total%20weight%20for%20group%201%20is%2075%25%2C%20and%20the%20weights%20for%20A%2C%20B%20and%20C%20in%20group%202%20add%20up%20to%2025%25%20which%20is%20also%20the%20total%20weight%20for%20group%202%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2091936%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20a%20formla%20of%20weighted%20average%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2091936%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20bringing%20this%20out!%20I%20have%20corrected%20the%20table.%26nbsp%3B%20The%20criterias%20weight%20adds%20up%20from%20the%20criterias%20A%2C%20B%20and%20C%2C%26nbsp%3B%20so%20the%2075%25%20comes%20from%20the%20criterias%20below%20and%20same%20logic%20for%20the%2025%25.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello!

 

I kindly ask your help to create formulas for an evaluation board. I have an evaluation of criterias, which have different weight percentage.  How to calculate the final score of evaluations, according to these percentage weights?

Big thanks in advance!

 

   Person APerson BPerson C   
CRITERIAS for group 1Percentage system EvaluationEvaluationEvaluation Evaluation legend 
Criterias  weight75% xxx 1poor
Criteria A30% 421 2neutral
Criteria B20% 421 3good
Criteria C25% 421 4excellent
         
Criterias for group 2        
Criterias weight25% xxx   
Criteria A8%       
Criteria B8%       
Criteria C9%       
         
TOTAL100%       
2 Replies

@HelenHi 

Why do the weights for A, B and C in group 1 add up to 100% while the total weight for group 1 is 75%, and the weights for A, B and C in group 2 add up to 25% which is also the total weight for group 2?

Hi @Hans Vogelaar 

Thanks for bringing this out! I have corrected the table.  The criterias weight adds up from the criterias A, B and C,  so the 75% comes from the criterias below and same logic for the 25%.