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...
A very reasonable question.
1. Use Excel's wonderful table capability
2. Put the formula doing the adding apart from the table; it will automatically include new rows.
And some unsolicited advice:
3. Use only one table for all expenses. Let Excel's Pivot Table break out the months for you.
I've attached a very simple example file. Feel free to come back with questions.
