What if I don't have the data in consecutive cell ranges?

For example:
Quality is cell b1
Attendance is cell b4
Hold is cell b5
Wrap up is cell b9

"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?