Hello,
For the first time, I am trying to calculate a weighted average. I think I got the weighted average formula correct: =SUM(B20*B25, C20*C25, D20*D25, E20*E25, F20*F25,)/SUM(B25:F25)
But we didn't get a score for the cash category, and need the 0% to not be counted. Is there something I add to this? or is there a better formula? My weighted average should work out to 73.08% for the camping line.
Thank you!
A B C D E F G
<colgroup><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>
For the first time, I am trying to calculate a weighted average. I think I got the weighted average formula correct: =SUM(B20*B25, C20*C25, D20*D25, E20*E25, F20*F25,)/SUM(B25:F25)
But we didn't get a score for the cash category, and need the 0% to not be counted. Is there something I add to this? or is there a better formula? My weighted average should work out to 73.08% for the camping line.
Thank you!
A B C D E F G
19 Department | Welcome | Sales | Cash | Attitude | General | Total |
20 Camping | 100.00% | 71.00% | 0.00% | 63.64% | 70.00% | 64.27% |
21 Nautical | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
23 Winter | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
24 Sacs | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
25 Car Racks | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
26 Weighted | 17.00% | 37.00% | 14.00% | 22.00% | 10.00% |
<colgroup><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>