Hello,
I'm hoping someone can help me with this.
I have a total score being calculated based on 5 options under 9 categories (below is the formula). I need to make add a 50% weighting to the first category and then evenly distribute to the remaining 8. Does anyone have the slightest idea how this can be accomplished?
=SUM(COUNTIF(I3:Q3,{"Needs Development","Basic","Intermediate","Advanced","Expert"})*{1,2,3,4,5})
<colgroup><col><col span="9"></colgroup><tbody>
</tbody>
I'm hoping someone can help me with this.
I have a total score being calculated based on 5 options under 9 categories (below is the formula). I need to make add a 50% weighting to the first category and then evenly distribute to the remaining 8. Does anyone have the slightest idea how this can be accomplished?
=SUM(COUNTIF(I3:Q3,{"Needs Development","Basic","Intermediate","Advanced","Expert"})*{1,2,3,4,5})
Talent Multiplier (50%) | Purpose Driven (6.25%) | Principled Agility (6.25%) | Results Oriented (6.25%) | Strategic Orientation (6.25%) | Innovation (6.25%) | Collaborative Relationships (6.25%) | Risk Mitigation (6.25%) | Change Champion (6.25%) | |
<colgroup><col><col span="9"></colgroup><tbody>
</tbody>