Good evening fellow's. I have a problem and wondering if someone can help. I have 8 columns and unknown of rows. Month to month I have different amount of transactions. So Col A is the Date, Col B i sthe Check Number, Col C is the Payee/Transaction, Col D is the category, Col E is if the check has cleared or not (indicated by C or or R), Col F is the Withdrawal Amount, Col G are the deposit, and Col H is the running total. On the bottom of the form, I have 3 items. In col F is have the total amount of Withdraws, col G is the total Deposits, and col H I have those two subtracted, which gives me a balance.
Now what I would like to do is also on the bottom give me a running total of all the Withdraws that are not "Not Budget". How would I write this?
Thanks Dan
[Solved] Add "Not Budget" total to checkbook register
[Solved] Add "Not Budget" total to checkbook register
Last edited by Hagar Delest on Tue Jan 14, 2025 12:54 pm, edited 2 times in total.
Reason: tagged solved.
Reason: tagged solved.
OpenOffice 4.1.14 on Windows 11 Pro
Re: Working On A Checkbook Register
How is a transaction marked when it is Not Budget? Knowing that, you could use the SUMIF function to total only those transactions.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Working On A Checkbook Register
Sorry, what is blank? Whatever it is, the best solution is probably to change that blank to a notation, maybe NB for "not budgeted", and use the SUMIF function.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Working On A Checkbook Register
Dear FJCC -
Sometime today I will create a dummy Checkbook Register to show what I'm doing.
Also wanted to mention that for some reason the forum is kinda of slow.
Dan
Sometime today I will create a dummy Checkbook Register to show what I'm doing.
Also wanted to mention that for some reason the forum is kinda of slow.
Dan
OpenOffice 4.1.14 on Windows 11 Pro
Re: Working On A Checkbook Register
Forum slowness has been reported, so we wait for a fix.
Apache OpenOffice 4.1.16 on Xubuntu 24.04.4 LTS
Re: Working On A Checkbook Register
FJCC - Here is the example of what I'm looking for. The only thing I need help in is getting all the Not Budget items at the bottom to give me a total. You'll see what I mean when you open the demo.
Thanks
Dan If the file didn't come through, I'm not sure on how to get the demo file to you.
Thanks
Dan If the file didn't come through, I'm not sure on how to get the demo file to you.
OpenOffice 4.1.14 on Windows 11 Pro
Re: Working On A Checkbook Register
This formula in D37 should get you what you want.
Code: Select all
=SUMIF(D8:D35,"Not Budget",F8:F35)OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Add "Not Budget" total to checkbook register
With semicolons instead of commas it does work...
AOO 4.1.16 & LO 25.8.3 on Windows 10
Re: Add "Not Budget" total to checkbook register
I thank you all for the help.
OpenOffice 4.1.14 on Windows 11 Pro