Formula goes awry when deleting row, #REF! error

[Kusaywa]

I enter info into my spreadsheet using a form which moves the top row down and inserts new data.
My formula works fine, continuing up the sheet.
If I delete any row other than the top row, my formula goes awry giving me a #REF! error up the column.
How do I delete a row without screwing up the formula?
Here's my formula: =IF(ISBLANK(C5),"",SUM(G6-E5+F5))
And here is the code for inserting a new row.
Thanks for any help

Private Sub Submit_Click()
Dim n As Long
With Sheets("Checkbook Register")

    .Rows("5:5").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromRightOrBelow
    n = 5
    
    .Cells(n, "B") = [Text(Now(), "MM-DD-YYYY")]
    .Cells(n, "C") = TextBox1.Value
    .Cells(n, "D") = TextBox2.Value
    .Cells(n, "E") = TextBox3.Value
    .Cells(n, "F") = TextBox4.Value
    
End With
Unload Me
End Sub

 

[DeficientOptimism]

You can try this formula

=IF(ISBLANK(C5),"",SUM(OFFSET(G5,1,0)-OFFSET(E5,1,0)+OFFSET(F5,1,0)))

 

[Kusaywa]

=IF(ISBLANK(C5),"",SUM(OFFSET(G5,1,0)-OFFSET(E5,1,0)+OFFSET(F5,1,0)))

This subtracts the amount in E6 for some reason. If I change G5 to G6 (where either E5 or F5 either adds or subtracts from G6) the total stays the same. Remember, I am totaling up and not down column G.
Additionally, there really is no reason for =IF(ISBLANK(C5),"", as there should never not be a transaction entry.