Auto sum

[Bob_Stephens1150]

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. 

[#2]

@Bob_Stephens1150 One way to achieve this is shown in the picture below:

[#3]

@Riny_van_Eekelen 

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.

[#4]

@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?