Forum Discussion
New Excel problem
I recently purchased Office H&S 2021for Mac. I'm not able to get running summaries like i used to. I use this spreadsheet like a check register with the e column being debit or checks and the f colum...
Newer versions of Excel are backward compatible so old formulas should still work.
If your version of Excel supports dynamic arrays but lacks Lambda then you could use SUMIFS
= SUMIFS(credits, date, "<="&date) -
SUMIFS(debits, date, "<="&date)to obtain a running total. With the latest versions of Excel it would be
= SCAN(0, credits-debits, LAMBDA(x,y,x+y))Either of these would write the entire column of balances calculated as a single formula.
It turns out for whatever reason, me pasting an entry from numbers into Excel was the problem.