SUMPRODUCT command of excel can be used for multiplying elements of two arrays of unequal lengths, though it is usually used for arrays of equal length.

Name: SUMPRODUCT command of excel can be used for multiplying elements of two arrays of unequal lengths, though it is usually used for arrays of equal length.
Brand: Quizplus
Rating: 4.8 (33 reviews)

Question

Quizplus · Accepted Answer

SUMPRODUCT requires the arrays to be of equal length because it performs element-wise multiplication followed by a sum of the products, and cannot do so if the arrays have different lengths.

SUMPRODUCT Command of Excel Can Be Used for Multiplying Elements