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.
=IF(AND(C3="",D3=""),"",INDEX($E$2:E2,LARGE(IF($E$2:E2<>"",ROW($E$1:E1)),1))-C3+D3)An alternative could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.