Hi,
I have a spreadsheet that I need to calculate a weighted score for each entered criteria - See table below.
Each bidder will be given a score out of 10 for each of the criteria. Each criterion will be given a 'weighting' which is a multiplier for the score. This will then give each bidder a weighted score on each of the criteria. The bottom row simply gives the sum total of the scores and the weighted scores. I am struggling with the formula, I have tried SUMPRODUCT but I think I am getting it wrong - can only please help
Thank you very much
<tbody>
</tbody>
I have a spreadsheet that I need to calculate a weighted score for each entered criteria - See table below.
Each bidder will be given a score out of 10 for each of the criteria. Each criterion will be given a 'weighting' which is a multiplier for the score. This will then give each bidder a weighted score on each of the criteria. The bottom row simply gives the sum total of the scores and the weighted scores. I am struggling with the formula, I have tried SUMPRODUCT but I think I am getting it wrong - can only please help
Thank you very much
Bidder A | Bidder B | Bidder C | |||||
Criteria | Weight | Score | Weighted Score | Score | Weighted Score | Score | Weighted Score |
A | 10 | ||||||
B | 8 | ||||||
C | 9 | ||||||
D | 6 | ||||||
E | 7 | ||||||
F | 5 | ||||||
G | 1 | ||||||
TOTAL |
<tbody>
</tbody>