Forum Discussion
How to Get Excel to Calculate When New Rows Added
Hello, Relatively new to using excel (beginner). I've built a budget sheet and am having excel calculate the expenses going down (rows) on a cell at the bottom using a formula. If I have more exp...
If you put 2 numbers in a row even if it 1 and 0, then in the 3rd row do an auto sum, you can insert a row between the 1st two and put a number in that cell. It will auto sum
0
1
=SUM(A1:A2)
0
2
1
=SUM(A1:A3) <-- will do change to A3 automatically
0
1
=SUM(A1:A2)
0
2
1
=SUM(A1:A3) <-- will do change to A3 automatically