Excel: Overall Avg Percentage, non-contiguous

[nwarnock]

Ok, I need more caffeine. What the heck is the formula for getting the
overall average score (cell C19)? I keep trying to use SumProduct but
it's in the back of my mind that it's overkill.

I've got the raw data, and based on that, it should come out to 83.80,
but I'm just drawing a blank on the formula!

A B C D E
1 Evals By Evals By Ops Avg Client Avg
Ops Clients Score Score
2 Team A 21 7 91.23% 83.04%
3 Team B 43 9 92.62% 94.44%
4 Team C 0 16 0.00% 95.60%
5 Team D 17 8 58.82% 81.03%
6 Team E 0 0 0.00% 0.00%
7 Team F 20 4 89.54% 59.52%
8 Locn 1 Ops Overall Avg 101 86.03%
9 Locn 1 Client Overall Avg 44 87.43%
10
11 Team G 39 2 73.70% 61.11%
12 Team H 48 0 81.85% 0.00%
13 Locn 2 Ops Overall Avg 87 78.20%
14 Locn 2 Client Overall Avg 2 61.11%
15
16
17
18 Total Evals 234
19 Overall Avg

Thanks!
N

 

[nwarnock]

The caffeine, or something, did it:

=(SUMPRODUCT(B3:C8,D3:E8)+SUMPRODUCT(B12:C13,D12:E13))/B19