[H] Formula for getting the average percentage of average percentages

[askJPB]

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!

SKILL	COUNT OF EVAL	QUALITY SCORES
VOICE	551	93.03%
EMAIL	301	91.58
CHAT	393	92.82
TOTAL	1245	92.61

<tbody>
</tbody>

 

[Joe4]

Welcome to the Board!

Use SUMPRODUCT, i.e.

=[COLOR=#ff0000]SUMPRODUCT(B2:B4*C2:C4)[/COLOR]/SUM(B2:B4)

 

[Fluff]

Hi & welcome to MrExcel.
How about
=SUMPRODUCT(B2:B4,C2:C4)/SUM(B2:B4)