Multiply each value by its corresponding weight
Sum all the weighted values
Sum all the weights
Divide the total weighted values by the total weights
Use the formula `=SUMPRODUCT(values_range,weights_range)/SUM(weights_range)`
Replace `values_range` with the cells containing the numbers
Replace `weights_range` with the cells containing the weights
Example: `=SUMPRODUCT(A2:A10,B2:B10)/SUM(B2:B10)`