I have written this code;

rngFoundAll.Formula = "=sum(C+E+G)"
rngFoundAll.Offset(0, -7) = "incomplete"

to do the above instead of the deleterow line. However this enters this
formula into the cell;

=SUM(I:I+E+G)

and I am not sure how to solve this as obviously this returns a
circular reference, plus i need to refer to the row number in the
formula.