Forum Discussion
Solved
help
Can someone please help me figure out how to do this? I am trying to get the column in blue to have a running total of deductions and credits from a total starting amount, and the end result at the b...
Let's say the starting balance is in H5, the Charge Amounts in E6 and down, and the Credit Amounts in F6 and down.
In H6:
=IF(AND(E6:F6=""), "", $H$5-SUM(E$6:E6)+SUM(F$6:F6)
Fill down.
This is more of a small essay than concise formula"
= LET(
transaction, credit-debit,
runningTotal, SCAN(initialBalance, transaction, ADDλ),
VSTACK(
IF(transaction<>0, runningTotal, ""),
SUM(initialBalance, credit, -debit)
)
)
where
ADDλ
= LAMBDA(x, y, x+y)