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 lia...
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?