I am in a unique situation where I would really like to auto fill an absolute reference formula to save me a ton of time typing in dollar signs for the rest of my life. Let me explain. Hopefully you can see the image below, but I have this simple budgeting formula running all down column G: =SUM(G4)+E5-F5-D5.

Capture1.jpg

I frequently move things like "Transfer to checking for Christmas" from one row to another, but when I do that, it breaks all the subsequent formulas. Now I know I could just copy the item and paste it in the row above, then go back down and delete it...but that's not how I want to do it. Dragging the cell is easier. Therefore I know I need the formula to absolutely reference the cells: =SUM($G$4)+$E$5-$F$5-$D$5.

Capture1.jpg

I'm pretty sure I need an INDIRECT formula, but that's beyond my expertise. Can you help? Thank you!