Hi,
No standard function, but you can create one easily
=SUMPRODUCT(Values, Weights)/Sum(Weights)
or in investment terms,
=SUMPRODUCT(Shares, Prices)/Sum(Shares)
note the above. It makes a big difference which range/array you put into the denominator, so be careful.
=SUMPRODUCT(A1:A5,B1:B5)/SUM(B1:B5)
is a specific example.
Bye,
Jay