The _______________ function sums a series of products in ranges of identical sizes, called arrays, that are parallel to each other in a worksheet.
A) SUMPRODUCT
B) SUMPROD
C) ADDPRODUCT
D) ADDPROD

Question

Quizplus · Accepted Answer

The correct function for this description is SUMPRODUCT, which calculates the sum of the products of corresponding values within arrays or ranges. SUMPROD, ADDPRODUCT, and ADDPROD are not valid Excel functions.

The _______________ Function Sums a Series of Products in Ranges