Excel SUMPRODUCT function
Function SUMPRODUCT
Description Excel SUMPRODUCT function multiplies ranges or arrays together then returns the sum of products.
Syntax SUMPRODUCT(array1, [array2], [array3], …)
array1 The first array or range to multiply and add.
array2 [optional] The second array or range to multiply and add.
array3 [optional] The third array or range to multiply and add.
Example:
This is actually = 1*12+2*13+3*14+4*15=140
Related Video Tutorials: