Which of the following is equivalent to "=SUMPRODUCT(A1:A4,B1:B4)"?
A) A1*A4 + B1*B4
B) A1*B1 + A2*B2 + A3*B3 + A4*B4
C) (A1+A4)*(B1+B4)
D) (A1+A2+A3+A4)*(B1+B2+B3+B4)
E) A1 + A4*B1 + B4

Question

Quizplus · Accepted Answer

The SUMPRODUCT function multiplies the corresponding values in two or more arrays, and then returns the sum of those products. So, =SUMPRODUCT(A1:A4,B1:B4) multiplies A1 by B1, A2 by B2, A3 by B3, and A4 by B4, and then adds the results. This can be expressed as A1*B1 + A2*B2 + A3*B3 + A4*B4, which is the equivalent of Choice B.

Which of the Following Is Equivalent to "=SUMPRODUCT(A1:A4,B1:B4)