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.

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


--
Regards,

Peo Sjoblom




"Erika" wrote in message
...
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.

Try this:

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

Biff

"Erika" wrote in message
...
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.