I am trying to create a budget spreadsheet that includes an ongoing total. In otherwords, when we add a deposit to a specific row then there is a totals column that keeps the updated amount of that row. When we subtract an amount from that same row, the totals of that row again changes in a negative way in the same totals column for that row.

Do I use a macro or is there a loop formula that can be added as an array that only changes when a change has been made to a certain row. Everything I have tried Excell tells me that I cannot do a loop command.

Any advice or possible formula would be exceedingly appreciated.