SUMPRODUCT Function Explained
The SUMPRODUCT Function in Microsoft Excel multiplies corresponding ranges or arrays together and returns the sum of products. It can be used to calculate weighted averages, or to calculate the total of a set of numbers that meet certain criteria. It takes up to 30 arguments, each of which can be a range, array, or constant.
SUMPRODUCT Function Syntax
SUMPRODUCT(array1, [array2], [array3], ...)
- array1: The first array or range of cells to multiply and then add.
- array2: (optional) The second array or range of cells to multiply and then add.
- array3: (optional) The third array or range of cells to multiply and then add.
- …: (optional) Additional arrays or ranges of cells to multiply and then add.