Array Formula for SUM IF in a row of a table that require "Greater Than"

Question

Hi i am looking over this issue in the other threads but i dont think this ever questioned before.

I want to use Array Formula of SUMIF to work as bank balance. Here is the data sample:

https://docs.google.com/spreadsheets/d/1O3dlXVtehg2nNuMgkaFGv7rHx7KEyiOq1QyD7yHBLi4/edit#gid=0

Basically, i know this will work:

=ArrayFormula(SUMIF((B8:B11)&(C8:C11),B8&(C8:C11),D8:D11))

But i dont know how to make this work:

=ArrayFormula(SUMIF((B8:B11)&(C8:C11),("<="&B8:B11)&(C8:C11),D8:D11))

I want a formula that sum every transaction BEFORE each date of each transaction IN THE SAME BANK and that works like arrayforumula that automatically return any data below it without us having to re-create or copying formulas when new data is added.

Well, this sounds complicated, but hopefully anyone understands. But just look at the link and you will understand.

Answer 1

try:

=ARRAYFORMULA(IF(C2:C="",,MMULT(N(TRANSPOSE(IF(
 (TRANSPOSE(ROW(C2:C))>=ROW(C2:C))*
 (C2:C=TRANSPOSE(C2:C)), D2:D, 0))), ROW(C2:C)^0)))