In this tutorial, you will learn how to use the SUMPRODUCT function in Excel. This powerful function allows you to perform mathematical operations on multiple ranges and returns the sum of the products of the corresponding array elements.
The SUMPRODUCT function allows you to multiply two or more arrays and then return the sum of the results. The syntax for the SUMPRODUCT function is SUMPRODUCT(array1, [array2], [array3],…), where array1, array2, etc. are the arrays you want to multiply and return the sum of the results.
This tells Excel to multiply the values in the range B2:B8 and the values in the range C2:C8 and then return the sum of the products of the corresponding elements in the two arrays.
In the example above, the calculation of the formula is: B2*C2+ B3*C3… B8*C8
When using the function, the number of arrays used in the SUMPRODUCT function should always be equal. This means that if you use two arrays in the SUMPRODUCT formula, both arrays should have the same number of elements. If the arrays are not the same size, the SUMPRODUCT function will return an error.