Tag Archives: Sumproduct

How to use Excel’s SUMPRODUCT()-function

An easy way to sum products of corresponding numbers in several arrays is to use Excel’s SUMPRODUCT()-function. It takes one or more arrays as parameters and calculates sum of products.
Following video demonstrates first the traditional way to do that and then same by using SUMPRODUCT()-function: