09Dec2014

How to use SUMPRODUCT function in Excel

SUMPRODUCT function in Excel returns the sum of the products of the corresponding ranges or arrays. Let’s check the syntax for this function. Formula Syntax: SUMPRODUCT (array 1, [array 2], [array 3], …) The arrays in the formula are the ranges of the cells that we wish to multiply.   SUMPRODUCT function in Excel: Let’s