I need to make a sum function always equal the corresponding cell
 

in cell a1 of sheet 1, i have an addition formula that contains
"=+AU1+BB1+'sheet2'!a1" if i insert a line above a1 on sheet 1 and it becomes
a2, the formula automatically changes to "=+AU2+BB2+'sheet2'!a1", how can I
get it to automatically change to "=+AU2+BB2+'sheet2'!a2"?

I need to make a sum function always equal the corresponding cell
 

Possibly

=AU1+BB1+INDEX(Sheet2!A:A,(ROW(A1)))

Mike

"tarabull" wrote:

in cell a1 of sheet 1, i have an addition formula that contains
"=+AU1+BB1+'sheet2'!a1" if i insert a line above a1 on sheet 1 and it becomes
a2, the formula automatically changes to "=+AU2+BB2+'sheet2'!a1", how can I
get it to automatically change to "=+AU2+BB2+'sheet2'!a2"?

I need to make a sum function always equal the corresponding cell
 

I don't know the specifics of what you're doing so the following may not
solve your problem but you can get the result you're seeking by selecting
both sheets before inserting a line. For example, with Sheet1 selected,
hold down the CTRL key and click on the Sheet2 tab. Both Sheet1 and Sheet2
are now highlighted and anything you do on Sheet1 will also be performed on
Sheet2. So inserting a line in Sheet1 will do the same in Sheet2... and
your formula will increment to the correct cell reference.

"tarabull" wrote in message
...
in cell a1 of sheet 1, i have an addition formula that contains
"=+AU1+BB1+'sheet2'!a1" if i insert a line above a1 on sheet 1 and it
becomes
a2, the formula automatically changes to "=+AU2+BB2+'sheet2'!a1", how can
I
get it to automatically change to "=+AU2+BB2+'sheet2'!a2"?