I am trying to take this formula and trying to expand it to the whole Column as opposed to having it per cell..
This sheet is for real estate. Taking balance from previous month balance and adding expenses and subtracting payments.
Currently we have
=SUM(H4,C5,G5)-F5
Currently after HOURS of research I found this which was not much help
This question was answered by Adam Lusk here: http://productforums.google.com/forum/#!topic/docs/fEXrwNolJYU
I have published a quick example with a non-working formula using OFFSET here: https://docs.google.com/spreadsheets/d/1AAqXyni9wSZV3ifrNnzrrn4ZkU_k65hRKysEsVbBMAM/edit?gid=0#gid=0
The formula that works:
=ARRAYFORMULA(D2 - SUMIF(ROW(A3:A20),"<="&ROW(A3:A20),A3:A20) + SUMIF(ROW(A3:A20),"<="&ROW(A3:A20),B3:B20))