Enter the values in one column
Enter the corresponding weights in another column
Multiply each value by its 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