Formula Auto-Adjustment

R

robot

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.
 
S

Shane Devenshire

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top