SUMPRODUCT
Definition
Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.
Sample Usage
Syntax
SUMPRODUCT(array1, [array2, ...])
array1
- The first array or range whose entries will be multiplied with corresponding entries in the second such array or range.array2, ...
- [ OPTIONAL -{1,1,1,...}
with same length asarray1
by default ] - The second array or range whose entries will be multiplied with corresponding entries in the first such array or range.
Notes
- Matrix multiplication,
MMULT
, can also be accomplished using a combination ofTRANSPOSE
andSUMPRODUCT
functions.
See Also
TRANSPOSE
: Transposes the rows and columns of an array or range of cells.
MMULT
: Calculates the matrix product of two matrices specified as arrays or ranges.
In order to use the SUMPRODUCT formula, start with your edited Excellentable: