Simple Account transactions and balance projections

[kyle.sullivan.me]

Re running balances on transactions sheet, see post here for solution.

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]