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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!