Use SUMPRODUCT to Calculate Weighted Averages | Learning ...

Although Excel doesn't have a weighted average function, it does have a function that ... This part is going to divide SUMPRODUCT by the SUM of the weights.

www.google.com.tw