It works in Google Sheets but not in Libre Calc ---

=arrayformula(vlookup(J3-0.01,sort({A4:A,sumif(A4:A,"<="&A4:A,B4:B)}),2,1))

This works in Google Sheets but not in Libre … Err:539

J3 is the Date of Next Deposit … Col A is the Date of all Transactions … Col B if the Value or each transaction …

2020 Credit Tracker 2.ods
This is the entire spreadsheet with all pages included.

Please describe in your words what you want to achieve.

The cell that this is in (K3) is suppose to display the balance on the day the next deposit is made, before the deposit is made. See attached spreadshet.

suppose to display the balance on the day the next deposit is made…

What do you mean by “the balance”? Please don’t take for granted that everybody understands the term “balance” with respect to your sheet. Is that the sum of all values in column B, whose related date in column A is before (or after?) current date (or “Next Deposit”?)- or is it something completely different? A clear description, of what you want to calculate will pave the road to a working formula. All other stuff like formulas from unknown applications is pure guesswork.

To be continued at question/279918/.