I tried the formula as you indicated below, but came up with a different sum.

B C
1 3 50%
2 4 25%
3 2 12.5%
4 3 12.5%
= 3.125

"Roger Govier" wrote:

Hi Whitney

With Values in B1:B4 and percentages in c1:C4
=SUMPRODUCT(B1:B4,C1:C4)
produces the result = 3.75
--
Regards
Roger Govier

"Whitney" wrote in message
...
I would like to calculate a weighted average for an overall score.

Example:
5 point scale
Quality - 3 weighted at 50%
Attendance - 4 weighted at 25%
Productivity
Hold Time - 2 weighted at 12.5%
Wrap Up - 3 weighted at 12.5%
Overall Score = average of the above
without weighting = 3
with weighting = ?
What formula can I use for the overall score to calculate a weighted
average?