Microsoft Excel Formula Help

Heres my problem.
In excel, I want to sum up certain cells in a column say b:30 to b:60. After I hit the autosum button, it puts the total sum right beneath the last value so it would appear in cell b61. The good thing about this is that if i happen to insert a cell (in say b35), the total in cell b62 would automatically update. What I want to do is move this autosum total into another column like c:30. but when i do this, it loses its autoupdating. how can i make sure that it keeps the autoupdating so that it adds up any extra values i add in column b.
Answer #1
You don’t want to move it. You need to just make a new formula using the autosum button in the desired cell. Click on cell c:30. Hit the autosum button and then click-hold and drag a box to include b:30 threw b:60. This will give you the desired effect of including any rows you add between 30 and 60 in your total. Give it a try. I just checked it to be sure I was right and it worked perfect.