Show Balance in a formula for all the column
I need to make a formula to show the balance in the entire column, but the formula column do not works properly.
I have doposit, cost and balance. Deposit (sum), cost (diference), balance is the deposit less cost and the next row is balance plus doposit less cost and show the new balance.
We need to copy when my rows fill all??
=Saldo597  TOTAL@row + Reembolso@row
thanks for your help
Answers

Sorry, can't @ you for some reason. Your formula has Saldo597 in it which is a static cell, which I am assuming is 220.77. If you need a total for your balance, I would recommend you either use sheet summary, =SUM(Saldo:Saldo), or create a new column that has total balance =SUM(Saldo:Saldo). Your Saldo formula should be =IFERROR(TOTAL@row + Reembolso@row, 0)
Help Article Resources
Categories
Check out the Formula Handbook template!