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.

Hello, Thanks for your feedback. Feedback is valid and we will try to amend the questions asap! Best, Ned

Good morning, thank you for the quick response. Loving the career track curriculum. Exactly what I've been looking for!

Follow this topic

Last answered:

21 Oct 2021

Posted on:

20 Oct 2021

Resolved: Practice Exam: Sensitivity Analysis Question

2 answers ( 1 marked as helpful)

Instructor

Posted on:

21 Oct 2021

Helpful answer

Posted on:

21 Oct 2021