Balance on transactions sheet

Hi all,
Also looked into this and created an array formula that can be entered into the header row on the transactions sheet. No sorting required, no pull-down of formulas after new transactions are filled.

={"Running Balance";
LET(
datesAll,B2:B,
amtsAll,M2:M,
acctsAll,T2:T,
MAP(acctsAll,datesAll,LAMBDA(acctRow,dateRow,SUMIFS(amtsAll,acctsAll,acctRow,datesAll,"<="&dateRow)))
)}

3 Likes