How To Get A Weighted Average In Excel?
To calculate a weighted average in Excel, simply use SUMPRODUCT and SUM. First, the AVERAGE function below calculates the normal average of three scores. Below you can find the corresponding weights of the scores. We can use the SUMPRODUCT function in Excel to calculate the number above the fraction line (370). How do I calculate […]