Resolved: Practice Exam: Sensitivity Analysis Question

The answer provided is: -17554687 using the formula in the answer key: =SUMIF(Data!E:E,Output!B3,Data!D:D)
However, that is wrong because it is adding both the initial value and total due from the data table which has duplicates

The correct formula would be for Output table E3: =INDEX(Data!D:D,MATCH(Output!$B3,Data!$E:$E,0))

Then drag to complete all of the amounts. then you can use a regular sum formula: =SUM(E3:E12) that results in -4824139, correct?

Unless of course you just wanted to use the Sumif function without any thought to duplicate amounts.