SUMPRODUCT function in excel can be used to
A) sum two columns/rows and then multiply the sum
B) multiply numbers of one column/row with the corresponding numbers of the other column/row
C) multiply corresponding numbers of two columns/rows and add the products.
D) either $\mathrm{A}$ or $\mathrm{C}$, since they will give the same result
E) none of the above

Question

Quizplus · Accepted Answer

The SUMPRODUCT function in Excel multiplies corresponding numbers in the given arrays (columns or rows) and then adds up those products.

SUMPRODUCT Function in Excel Can Be Used to A) Sum A\mathrm{A}A

SUMPRODUCT Function in Excel Can Be Used to
A) Sum $\mathrm{A}$