Which command is equivalent to =SUMPRODUCT(A1:A3,B1:B3)?
A)=SUM(PRODUCT((A1:A3,B1:B3))
B)=PRODUCT(SUM((A1:A3,B1:B3))
C)=PRODUCT(A1+B1,A2+B2,A3+B3))
D)=A1*B1+A2*B2+A3*B3

Question

Quizplus · Accepted Answer

The command A1*B1+A2*B2+A3*B3 is equivalent to =SUMPRODUCT(A1:A3,B1:B3) as it multiplies the corresponding values in the two arrays and then adds the results together, which is exactly what SUMPRODUCT does. The other options do not give the correct result for the given arrays.

Which Command Is Equivalent to =SUMPRODUCT(A1:A3,B1:B3)