Hi Guys,
A little bit of help.
=(B2*C2+B3*C3+B4*C4)/SUM(B2:B4)
This is my formula for getting the average percentage of average percentages but what is I have more than 3 rows that needs to average? Let's say 100 rows of average scores. How do I shorten my formula? Thanks!
<tbody>
</tbody>
A little bit of help.
=(B2*C2+B3*C3+B4*C4)/SUM(B2:B4)
This is my formula for getting the average percentage of average percentages but what is I have more than 3 rows that needs to average? Let's say 100 rows of average scores. How do I shorten my formula? Thanks!
SKILL | COUNT OF EVAL | QUALITY SCORES |
VOICE | 551 | 93.03% |
301 | 91.58 | |
CHAT | 393 | 92.82 |
TOTAL | 1245 | 92.61 |
<tbody>
</tbody>