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.
