[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!

[TABLE="class: outer_border, width: 300"]
<tbody>[TR]
[TD]SKILL[/TD]
[TD]COUNT OF EVAL[/TD]
[TD]QUALITY SCORES[/TD]
[/TR]
[TR]
[TD]VOICE
[/TD]
[TD]551
[/TD]
[TD]93.03%[/TD]
[/TR]
[TR]
[TD]EMAIL[/TD]
[TD]301[/TD]
[TD]91.58
[/TD]
[/TR]
[TR]
[TD]CHAT[/TD]
[TD]393[/TD]
[TD]92.82
[/TD]
[/TR]
[TR]
[TD]TOTAL
[/TD]
[TD]1245[/TD]
[TD]92.61[/TD]
[/TR]
</tbody>[/TABLE]

 

[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)