I want to create a budget in excel...and for my expenses section, i want to create "total expenses" cell...that updates each time i have a new expense. How can i do this, without having to update the formula? Currently, the formula has a range of cells in it to add but if I add new cells, I'd have to update the formula each time.
Hi Madih35
My solution is this:
Make sure there is a blank row just above the Total expenses cell.
Rewrite the formula to include the blank cell as well and save.
Every time you have a new expense which requires a new row, insert a row and type in the new cell, instead of typing in the existing blank cell. Your formula will be updated automatically.
Best of luck
Dear Madiha35, I would recommend the use of the Table Function in Excel. Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to. Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you. Step 1: Enter your data into the worksheet. Step 2: Create Table Highlight the relevant data On the insert tab, click on Table Step 3: Verify Table range is correct, Click OK Step 4: Select the cell you where you wish to Sum Data. Click on Autosum. Step 5: To Insert new data Click on the sum row in the table, (Not the entire worksheet row) Right click, Insert, Insert Table rows from above Step 6: Enter new data in row Step 7: Data is automatically calculated in formula.
310 views
Usually answered in minutes!
×