Weighted Average

[Michael Shapiro]

Sorry if this post has been answered elsewhere, I searched but did not find the answer I need.

Trying to average weighted scores. We have x1 number of students with a y1 GPA, plus x2 number of students with a y2 GPA. How do I manage to get the "total" (blended) average across the two groups?

I've tinkered with the SUMPRODUCT command without success, so I'm clearly missing something here.

Thanks in advance for your assistance.

Mike

 

[footoo]

((x1*y1)+(x2*y2))/(x1+x2)

 

[Michael Shapiro]

Thanks footoo. Ended up with something very similar: =SUM(x1*y1,x2*y2)/(x1+x2)

((x1*y1)+(x2*y2))/(x1+x2)