web analytics

Function 10 – SUMPRODUCT

To calculate the sum of the products of corresponding numbers in one or more ranges, use Excel’s powerful SUMPRODUCT function.

Explanation: the SUMPRODUCT function performs this calculation: (2 * 1000) + (4 * 250) + (4 * 100) + (2 * 50) = 3500. The SUMPRODUCT function is an extremely versatile function and can produce the same result as many built-in functions in Excel and even array formulas