SUMPRODUCT

Definition: The SUMPRODUCT function in Excel is used to find the sum of the product of two or more arrays.

Syntax: ==SUMPRODUCT(array1, [array2], …).

Situation: This formula is appropriate in situations where you need to find the sum of the product of two or more arrays.

Example: If you have two arrays A1:A10 and B1:B10, you would use the formula =SUMPRODUCT(A1:A10, B1:B10). This would return the sum of the product of the two arrays.