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

To determine the Net Flow values in cell K6, we need to subtract the outflows from the inflows for each category. The inflows are represented by the cells in column B, while the outflows are represented by the cells in column E. We need to sum the inflows and subtract the outflows to get the net flow for each category. Therefore, we should use the formula:
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 one that uses this formula. Option A and B use SUMIF(), but they do not correctly subtract the outflows. Option D uses SUMPRODUCT() which is not appropriate for this calculation.

Which Formula Should Be Used to Determine the Net Flow