Microsoft Office Questions? Ask a IT Expert for Support ASAP
I already new that. I want the solution to the problem.
There should be a way to adjust the cell formula addresses automatically when ithe row changes up or down.
row 21 cell G21 was =($G$20-$E$21 row 22 cell G22 was =($G$21-E$22)
I deleted row 21
row 22 became row 21 and cell G21 became #REF!
It calculating a new total based on the previous row G cell plus or minus the value in the current row E cell.