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)SUMPRODUCTB6: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)SUMPRODUCTB6:B16,G6:G16)

Quizplus · Accepted Answer

The Net Flow values represent the difference between the sum of inflows and outflows for each category. The formula that best captures this concept is option C, which uses SUMIF to sum the values in the inflow and outflow columns based on the category name in column I, and subtracts the outflow amount from the inflow amount. Option A and B do not take into account the inflows and outflows, whereas option D uses a different approach to calculate a product of the corresponding inflow and outflow values.

Which Formula Should Be Used to Determine the Net Flow