Formula to generate a weighted average score
I'm trying to create a formula that will generate a weighted sum total across a couple of criteria columns after each column has been assigned a score.
Each of the columns will have a drop down where we can select a score (from 1 - 10). Each column will have a different weight:
Enterprise Priority: 35%; HR Priority Score: 25%; Costs Savings Score: 25%; HR Modernization: 15%
I would like the weighted score to be populated in the "HR Leadership Score" column.
How I would normally do this in Excel is not working at all, so any assistance would be appreciated!
Help Article Resources
Check out the Formula Handbook template!