In Excel, the worksheet needs to be prepared prior to running the Solver. As such, the total (total return), cell G8, shows the total of the expected return for approved projects. What is the formula that must be set in G8 to capture the results accurately?

A) =SUM(B8:E8 * B10:E10)
B) =SUMPRODUCT(B8:E8, B10:E10)
C) =SUMPRODUCT(B8:E8 * B10:E10)
D) =SUMPRODUCT(B8:E8, G2:G5)

Question

In Excel, the worksheet needs to be prepared prior to running the Solver. As such, the total (total return) , cell G8, shows the total of the expected return for approved projects. What is the formula that must be set in G8 to capture the results accurately?

A) =SUM(B8:E8 * B10:E10) 
B) =SUMPRODUCT(B8:E8, B10:E10) 
C) =SUMPRODUCT(B8:E8 * B10:E10) 
D) =SUMPRODUCT(B8:E8, G2:G5)

Quizplus · Accepted Answer

The correct formula is =SUMPRODUCT(B8:E8, B10:E10). SUMPRODUCT multiplies ranges or arrays together and returns the sum of products, which is suitable for calculating the total return by multiplying each project's return by its corresponding approval status (1 or 0) and then summing those products.

In Excel, the Worksheet Needs to Be Prepared Prior to Running