What does the Excel "=SUMPRODUCT(A1:A5,C6;C10)" function do?
A) Sums each range and multiplies the sums.
B) Sum each pair of cells and multiples each sum.
C) Multiplies the contents of cells containing the =SUM() command.
D) Multiplies each pair of cells in two arrays matched by position and sums the products.

Question

Quizplus · Accepted Answer

The SUMPRODUCT function multiplies each pair of cells in two arrays that are matched by position and then sums the products. In this case, it multiplies the values in the range A1:A5 with the corresponding values in cells C6 through C10 and then adds up the resulting products.

What Does the Excel "=SUMPRODUCT(A1:A5,C6;C10)" Function Do