title: How to create a runing total formula that expands automatically when new rows are added to my spreadsheet
body: <p>Hello right now I have a simple deposit / expense spreadsheet where I have a sum formula that does down column C adding(or subtracting) from what is put into column B.  Formula is =SUM($B$1:B1)  This works great for the rows that are created however when I add a new row. I have to drag down the forumula in C to cover the new row before it will calculate the new total.   I would like this to be done automatically.  IE I add a new row and it calculates C from what I entered in B and the history in C.    Can't seem to find how to do this.  Am using Google Spreadsheets so unsure if this is even possible.</p>
  
  <p>This other question seems to be very complex coding for something else.  My question was answered however by user JPV below.  Thanks to him for his time.</p>