A genius has helped me get here, but I cannot go any further on my own.
This is the scenario:
The formula in column G is:
={"Running Balance";map(A3:A8;B3:B8;C3:C8;D3:D8;E3:E8;lambda(Σ;Λ;Γ;ξ;Ξ;if(Σ="";;max(0;sumifs(E3:Ξ;D3:ξ;ξ;A3:Σ;Σ;B3:Λ;Λ)-Γ))))}
but it is not yielding the same result as it should in column H
Here is the file:https://docs.google.com/spreadsheets/d/1gh5w0czg2JuoA3i5wPu8_eOpC4Q4TXIRhmUrg53nKMU/edit?usp=sharing
Any help is greatly appreciated!