Monday, January 4, 2016

yogi_Compute Row By Row Running Total For CheckBook Register Where New Transaction Is Posted Above (Rather Than Below) Last Transaction Row

Google Spreadsheet   Post  #2007
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jan-04-2016
post by: OneBinary:!topic/docs/XnDCCLsWOaI;context-place=forum/docs
How to utilize ArrayFormula to auto-fill formula on new row insert on check book register?

I've been doing a ton of reading, but I'm having trouble figuring out how to utilize the ArrayFormula function to automatically fill in a formula when a new row is inserted.

I'm trying to develop a check book register, but one key difference is I want to insert new entries at the top (so that my current balance is always at the top and old transactions get pushed down).  For the Balance field I'm calculating that by: (Previous Balance - New Transaction = Current Balance).  (If a deposit occurred, I enter New Transaction as a negative number).

Now every time I want to insert a new transaction I want to insert a new row at the top and have the Balance formula auto-populate, however for the life of me I can't seem to get it right due to the circular reference error when referencing 'Previous Balance'.

Is anybody able to help me on this?