CODEWITHSUNDEEP
javascriptexcelgoogle-apps-script
user3196599
user3196599

Reputation:

Google Sheet Function to calculate blance

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

https://support.google.com/drive/answer/71291?hl=en

Upvotes: 1

Views: 84

Answers (1)

fooby
fooby

Reputation: 849

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: http://goo.gl/NF6T24

The formula that works:

=ARRAYFORMULA(D2 - SUMIF(ROW(A3:A20),"<="&ROW(A3:A20),A3:A20) + SUMIF(ROW(A3:A20),"<="&ROW(A3:A20),B3:B20))

Upvotes: 1

Related Questions