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 formula to calculate the Net Flow values should subtract the Outflow values from the Inflow values for each country. In this case, the Inflow values are in column B and the Outflow values are in columns C and E. Therefore, the formula should subtract the SUMIF result of column C from the SUMIF result of column E for each country. Option C correctly represents this logic. Options A and B use incorrect ranges and criteria for the SUMIF functions. Option D calculates the product of the Inflow and Net Flow values, which is not the correct approach for calculating Net Flow.

Which Formula Should Be Used to Determine the Net Flow