In other words, some values have more “weight”.
In a nutshell, SUMPRODUCT multipliesrangesorarraystogether and returns the sum of products.
Seethis pagefor an overview.
See below for an example where weights do not add up to 1.
However, the scores in C5:E5, which arerelative reference, change with each new row.
The result is a weighted average for each name in the list as shown.
Transposing weights
The SUMPRODUCT function requires that array dimensions be compatible to run correctly.
If dimensions arenotcompatible, SUMPRODUCT will return a #VALUE error.
To prevent this problem, you may need to transpose the weights to match the data.
From this point, the formula is solved the same way as explained earlier.
These values can be numbers, cell references, ranges, arrays, and constants, in any combination.
SUM can handle up to 255 individual arguments.
AVERAGE Function
The Excel AVERAGE function calculates the average (arithmetic mean) of supplied numbers.
Related videos
How to calculate an average value
What is an array formula?
