Which formula should be used to determine the Net Flow values in cell K6 in the following spreadsheet model?
A) SUMIF($C$6:$C$16,I6,$B$6:$B$16)-SUMIF($E$6:$E$16,I6,$B$6:$B$16)
B) SUMIF($I$6:$I$12,B6,$B$6:$B$16)-SUMIF($I$6:$I$12,I6,$B$6:$B$16)
C) SUMIF($E$6:$E$16,I6,$B$6:$B$16)-SUMIF($C$6:$C$16,I6,$B$6:$B$16)
D) SUMPRODUCT(B6:B16,G6:G16)

Question

Which formula should be used to determine the Net Flow values in cell K6 in the following spreadsheet model? 
A) SUMIF($C$6:$C$16,I6,$B$6:$B$16)-SUMIF($E$6:$E$16,I6,$B$6:$B$16) 
B) SUMIF($I$6:$I$12,B6,$B$6:$B$16)-SUMIF($I$6:$I$12,I6,$B$6:$B$16) 
C) SUMIF($E$6:$E$16,I6,$B$6:$B$16)-SUMIF($C$6:$C$16,I6,$B$6:$B$16) 
D) SUMPRODUCT(B6:B16,G6:G16)

Quizplus · Accepted Answer

The Net Flow values represent the difference between the inflow and outflow values for each sector. In this model, the inflow values are in column E and the outflow values are in column C. Therefore, we need to subtract the sum of outflow values from the sum of inflow values for each sector. The correct formula to achieve this is: 
SUMIF($E$6:$E$16,I6,$B$6:$B$16) - SUMIF($C$6:$C$16,I6,$B$6:$B$16)

Option C is the only choice that presents this formula correctly.

Which Formula Should Be Used to Determine the Net Flow