Which Formula Should Be Used to Determine the Net Flow

Multiple Choice

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)