Jul 29 2022 01:22 PM
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 expenses than I currently have rows and want to add more rows as expenses come in, how do I have the "total cell" that's got the formula for calculating everything also calculate the new added rows? I'm not familiar with the table option, so I don't know if I need to be using that to achieve this or not.
Thanks,
Spacko
Jul 29 2022 01:32 PM
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.
Jul 29 2022 01:33 PM
Aug 04 2022 08:03 AM