Linkied Formula Help

[Guest]

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.

 

[Peo Sjoblom]

=SUM(INDIRECT("'Sheet1'!A1:G1"))

 

[T. Valko]

Try this:

=SUM(INDIRECT("Sheet1!A1:G1"))

Biff