sumproduct

MATT · Sep 30, 2003

Industry Mkt Val YTW
a 5 5
b 10 6
b 15 7
a 20 8

What formula can I write to give me the weighted average
YTW for industry A and B?

Paul · Sep 30, 2003

MATT said:
Industry Mkt Val YTW
a 5 5
b 10 6
b 15 7
a 20 8

What formula can I write to give me the weighted average
YTW for industry A and B?

Is this what you mean?
=SUMPRODUCT((A2:A5="a")*B2:B5*C2:C5)/SUM(B2:B5)
Gives 3.7 for a and 3.3 for b.