Multiplies corresponding components in specific arrays, and returns the sum of those multiplications.
The syntax of the function is the following:
SUMPRODUCT(array1, [array2], …)
array1, [array2], …: The arrays whose components we want to multiply and then sum. Only the first argument is required and the other are optional (up to 255).
The arrays must have the same dimensions, or an #VALUE! error will be thrown.
Any array components that are not numeric are considered zero.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the SUMPRODUCT function:
Use the proper function in the cell G18 to calculate the sum of the products of the respective columns of the three tables. Do not use the SUM function.