SUM formula

Question

Column B needs to contain a formula to get total of Column A
A B
8 8
7 15
6 21

What is it to get below after insert a row under header of 'A B' ? Thanks
A B
9 9
8 17
7 24
6 30

Answer 1

Hi Ian

Happy New Year to you too.

When you insert a new row, all of the cells that have moved down as a result of the new row will have their formulas adjusted accordingly automatically. No need to do anything with them. The only cell that will need some help will be the cell in the new row in the column that has the formulas in it - in your example, column B. All you have to do to correct that is to go to the cell with the formulas in it above the inserted new row and drag the formula down to the new row. That will insert the correct formula into the new cell.

Hope this helps.
David

Answer 2

David,

Thank you for your solution. After the formula =IF(A2="","",B1+A2) drag down, I get the right results.
So the formula from B2 and below follow the format of =IF(An="","",Bn-1+An)
Is there a way to keep the format in each cell after insert a row? Thanks

Happy New Year!

Ian

Answer 3

Hi Ian

In cell B1, enter the formula =A1
In cell B2, enter the formula =IF(A2="","",B1+A2)
Then drag the formula from cell B2 as far down the column as you need.

I hope this solves your problem.

David