Hello,

I have a formula that references cells on another worksheet (say sheet1).
The formula looks like this:
=sum(sheet1:A1:A8)

When I remove two rows (row 2 and row 3) from sheet1, the formula is
adjusted automatically to:
=sum(sheet1:A1:A6)

However, this is not what I want. How do I keep the original formula
sum(sheet1:A1:A8) even if rows are deleted?
I tried sum(sheet1:$A$1:$A%8), but to no avail.

Any help would be appreciated.

Hi,

Try

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

Be careful - your formula shows a ":" between the sheet name and the address
it should be an "!".

Also, in my formula be careful - there is a single quote 1. after (" 2.
and another one before !

If this helps, please click the Yes button

Cheers,
Shane Devensnhire

"robot" wrote in message
...
Hello,

I have a formula that references cells on another worksheet (say sheet1).
The formula looks like this:
=sum(sheet1:A1:A8)

When I remove two rows (row 2 and row 3) from sheet1, the formula is
adjusted automatically to:
=sum(sheet1:A1:A6)

However, this is not what I want. How do I keep the original formula
sum(sheet1:A1:A8) even if rows are deleted?
I tried sum(sheet1:$A$1:$A%8), but to no avail.

Any help would be appreciated.