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: