I have a formula that looks at sheet1 and cells a1:g1. How do I make it so
even if rows are deleted or added the formula will also add up the
information on sheet1 cells a1:g1

I usually have to delete column A which moves the information over and then
I add new information in column g. I keep getting errors with all of my
formulas.