To calculated a weighted average you can use the SUMPRODUCT function together with the SUM function. This is illustrated in the example below. Calculating Weighted Average in Excel SUM Function While SUMPRODUCT function is the best way to calculate the weighted average in Excel you can also use the SUM function.
Calculating Weighted Average in Excel SUM Function While SUMPRODUCT function is the best way to calculate the weighted average in Excel you can also use the SUM function.
You can use SUMPRODUCT formula. And there you have it. In the data given below we see the average amount of shopping done by the number of households that are categorised or clustered in buckets based on certain characteristics. Calculate the SUMPRODUCT ie multiply each value by its weight and then calculate their sum in order to get.