Tuesday, November 25, 2014

yogi_Compute Row By Row Balance For A Check Register Type SetUp With Starting Balance

               Google Spreadsheet   Post  #1845
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-25-2014
post by Richard Puerto:
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/KnDT04pZ6kY
Needing help with an ArrayFormula, please.
I created a check register spreadsheet and would like to use an array formula to calculate the balance in a more efficient manner as opposed to a formula for each cell. The problem is that I have to subtract from the cell above in the prior row. This is the formula:

=ARRAYFORMULA(If(AND(ISBLANK(D3:D1000),ISBLANK(E3:E1000)),"",F2 - D3:D1000 + E3:E1000))

I can't figure out how to subtract from the cell/row (F2-999) in the row above while using the proper syntax for the array formula. It is also calculating a balance when cells in D and E are blank, but it shouldn't.

I have shared the sheet :


Thanks for any possible help.
--------------------------------------------------------------------------------------------------