Weighted Average calulation using Excel

[Marcie Be]

I am using SUMPRODUCT/SUM for mutiple sets of data to get the combined weighted average.
I have done this by adding (SUMPRODUCT/SUM)+(SUMPRODUCT/SUM) mutiple times. It doesn't work unfortunately. How can this be done please? I need some help.

 

[AhoyNC]

Here is one way:

Book1
	A	B	C	D
1	Value	Weight		Weighted Average
2	90	3		122.35
3	125	4
4	125	4
5	90	3
6	150	3
7	150	3
8	90	3
9	125	4
10	150	3
11	125	4
Sheet1

Cell Formulas
Range	Formula
D2	D2	=SUMPRODUCT($A$2:$A$11,$B$2:$B$11)/SUM($B$2:$B$11)
B2:B11	B2	=COUNTIF($A$2:$A$11,A2)

 

[Marcie Be]

Here is one way:

Book1
	A	B	C	D
1	Value	Weight		Weighted Average
2	90	3		122.35
3	125	4
4	125	4
5	90	3
6	150	3
7	150	3
8	90	3
9	125	4
10	150	3
11	125	4
Sheet1

Cell Formulas
Range	Formula
D2	D2	=SUMPRODUCT($A$2:$A$11,$B$2:$B$11)/SUM($B$2:$B$11)
B2:B11	B2	=COUNTIF($A$2:$A$11,A2)

Thank you