Forum Discussion
Formula to calculate between "Closing Balances"
Hi, I have a sheet which uses formula to calculate balance for repayments and draw for a facility. Each period can have a different number of draws & repayments, but i wish to have a summary ba...
See attached. I have entered this formula in I6, and then copy/paste it to P6, I9 and P9. You can the same for every following period.
=SUMIF($A:$A,$A5,I:I)Personally, I would favour an approach where you just list all draws and repayments in one continuous list and than insert sub-totals (Data / Subtotal), whenever you needed/desired. This can be done with a few mouse-clicks and does not mess-up your data or formulae. This is demonstrated in the second sheet. Here, I also simplified some of your formulae, by eliminating most of the IF functions.