Maintaining a formula in a cell when there was an insert row
 

Thanks in advance for your help. Lets say I have A1 through A10 with a total
in A11. If I insert a row right after A10 then A11 becomes A12. My question
is how do I maintain that the new A12 will include the new A11 in my total. I
have alot of totals so it is a pain to manually change the formula for each
cell.

Thanks again.

Maintaining a formula in a cell when there was an insert row
 

Maybe you can change your total formulas:

In a11:
=sum(a1:offset(a11,-1,0))


Devin wrote:

Thanks in advance for your help. Lets say I have A1 through A10 with a total
in A11. If I insert a row right after A10 then A11 becomes A12. My question
is how do I maintain that the new A12 will include the new A11 in my total. I
have alot of totals so it is a pain to manually change the formula for each
cell.

Thanks again.

--

Dave Peterson

Maintaining a formula in a cell when there was an insert row
 

I'm not sure I understand your problem. I just tried what you described,
and, as I expeted, no problem. I entered numbers in A1 - A10, then
"=SUM(A1:A10)" in cell A11. I then inserted a new row above A11, entered a
vlue in the new A11, and the formula, which is now in A12, automatically
changed to "=SUM(A1:A11)", and reflected the new number entered in A11.

Am I missing something here?

Craig

"Devin" wrote:

Thanks in advance for your help. Lets say I have A1 through A10 with a total
in A11. If I insert a row right after A10 then A11 becomes A12. My question
is how do I maintain that the new A12 will include the new A11 in my total. I
have alot of totals so it is a pain to manually change the formula for each
cell.

Thanks again.