How to delete rows using formulas

[Rere]

have a spreadsheet of employees' names, #'s, etc. I need to delete rows
and add new names, etc. The formulas says =+SUM(A73+1) for example. I can't
just highlight the row and delete because it gives me an error #REF!+1.
Please help.

Someone tried to help me but then I got the error #value!.

This is a numerical sequence 1,2,3, etc.

 

[Peo Sjoblom]

Please stay in the original thread, Ron already posted a follow up there