Enter the values in one column
Enter the weights in a second column
Multiply each value by its corresponding weight
Sum the weighted values
Sum the weights
Divide the sum of weighted values by the sum of weights
Use the formula `=SUMPRODUCT(A2:A10,B2:B10)/SUM(B2:B10)`
Replace `A2:A10` with the values range
Replace `B2:B10` with the weights range
Use `=SUMPRODUCT(values_range,weights_range)/SUM(weights_range)` for any selected ranges