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.
Thanks for your feedback. Feedback is valid and we will try to amend the questions asap!