SoftMaker.com

Maybe the attached GIF sheds some light. balance.gif It does not. I know how to copy the formula to span several cells. The problem is moving a cell that is referenced in the balance formula, results in the formula changing automatically to reference the same cell, even though that cell has moved.

I'm very confused, that's what I'm doing. Like I left click the range/cells, then move it down. But then the formula in the cell NOT included in that range changes to reference the old cells in their new place. Does that make sense?

I have a formula that I would like to stay exactly how it is even when cells are moved. (It is the balance column of a budget sheet) However it moves to the previously referenced cell when I move that cell. I'll explain better with the example. Example: F4: =C4+E4+F3 A4 is the date, C4 is Income, E4...