Running Balance on Transactions Sheet

[Mark.S]

I’m curious if you could try/compare/comment on what you have here vs this?

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

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))) )} [image]