Hello,
Can formulas keep a running balance in column P of the Register sheet?
Thank you
Hello,
Can formulas keep a running balance in column P of the Register sheet?
Thank you
Are you referring to a running sum beginning in P18? If so, try =SUM($O$18:O18)
HTH
Regards, Jeff
Thanks I want each row to update amounts beginning with P11. I realize it isn't continuous is why I am having trouble.
I want it this way so I can sort the table but keep the accounts at top.
I filled in column P manually with amounts that I would like formulas to achieve.
Is this possible?
I don't think the amounts are correct carried down
Last edited by billy60; 01-12-2024 at 05:52 PM.
Not possible that I can see. That blank row throws a wrench into everything. I'll give this to the pros.
I tried another way. I removed that column from table and have the running totals in column Q. The only problem I see is the formulas for the running totals need to be far enough down to cover future entries.
Make it part of the table and it will adjust along with the table.
I run into the first row issue again though.
Perhaps this will help.
In the file attached to post #4 I converted the data in rows 10:16 into an Excel table (Register_S).
The formula for column P in that table is populated using: =SUM(INDEX(Resgister_S[[#All],[Running Balance]],ROW()-10),[@Deposit],-[@Payment])
Column P in the Register_T table is populated using: =SUM(INDEX(Resgister_S[Running Balance],ROWS(Resgister_S[Running Balance])),SUM(INDEX([Deposit],1):[@Deposit],-SUM(INDEX([Payment],1):[@Payment])))
Note that the original amounts were pasted into column R and column S shows the check. A few of the checks, such as in row 70, show as false however the amounts in columns P and R match to 2 decimal places (P70 displays 8,945.66 and R70 displays 8945.66 but contains 8945.66000000001).
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Great! Thank you very much JeteMc.
I get a warning: parts of your document may contain personal information and can't be removed by document inspector.
Last edited by billy60; 01-12-2024 at 09:58 PM.
I can't save document now without this warning popping up.
I don't get that warning, although I have seen it with other .xlsm files.
When I looked again at the formula for cells P18 and down I found a mistake.
The formula should read:Formula:Please Login or Register to view this content.
That corrected the formula issue but I still cannot save the file now. I don't know what to do.
I unchecked remove personal information under privacy and now I can save the file.
Thank you very much for your help JeteMc
You're Welcome. Thank You for the feedback, for the added reputation and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks