The first rental covers seven items for three days, so 35 item-days is worth investigating. In this example B2 is 7, C2 is 3, and C3 is the next rental’s duration of 5.

Follow the arrows into D2

Select D2 in Ulet and choose Formulas → Trace Precedents. The two arrows come from B2 and C3 because the formula is =B2*C3. Check the formula bar and row labels before deciding which reference to edit.

Arrows point from B2 and C3 toward D2, which currently returns 35 item-days.

Illustrated audit. The duration arrow crosses rows.

Recheck the source row and result

Enter =B2*C2. Remove the old arrows and trace again. Both arrows should start on row 2 and D2 should show 21. A change to the second rental’s duration should leave this row alone.

The corrected formula uses B2 and C2, and the rental total is 21 item-days.

Illustrated repair. Trace the two inputs again after editing.

Microsoft Excel instructions