Forum Discussion
Auto sum
I'm setting up my monthly cash flow chart using Exel 2010 version spreadsheet. I'm 62 yrs young and I know how to get total using column G as my balance, column E as my assets, and column F as my liabilities. for example =G10-F11
or =G11+E12. But what I want to learn to do is set up a formula so when inputting a liability F it will automatically subtract from the total. the same as inputting an Asset in E it would automatically add to the total.
3 Replies
Bob_Stephens1150 One way to achieve this is shown in the picture below:
Hi, thank you for your input.
Your formula worked for the row activated but when I input a liability15 in F3 then activated cell G3 it did not total for me.
I need a formula that will auto add and subtract the total for columns E, F, =G
every time I add data to the spreadsheet.
Bob_Stephens1150 Perhaps the attached example can help. Here I used a structured table. Add something I columns E or F directly below the table and it will extend and copy down the formula in G automatically. Is that what you had in mind?
