Mean is one of the most common calculation we do. But, the arithmetic mean that =AVERAGE() calculate assumes equal weights for all the values. Often times, we want to assign different weights for each of the values. Such calculation can be achieved by function
=SUMPRODUCT(array1, array2…)
- array1 represents a list of cells.
- array2 represents a list of different cells.
- The key is that the # of cells in both array1 and array2 must match.
Please use the following interactive video to practice.
Please click the link to open in full screen.