Enter the values in one column
Enter the corresponding weights in another column
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
Press Enter to get the weighted average
Example: `=SUMPRODUCT(A2:A5,B2:B5)/SUM(B2:B5)`