Oct 15 2020 05:33 PM
Hello... I'm fluid in mid basic excel worksheets.. I could not find the wording to search here for what I am trying to do, so figured Id just ask.
I have a budget worksheet... it goes like this:
----Paid---- ---Account name---- ----due date---- ---monthly payment----
Its sorted by due date and there is a total at the bottom of all the monthly payments.
I check off under the paid column when its paid and I like the amount in the monthly payment column to then subtract that amount from the total at the bottom..
Can this be done? is it wicked difficult to do?
any help with the info and formula would be appreciated and my budget/creditors appreciates it too.......
Thanks all,
Kevin
Oct 15 2020 08:54 PM
Hard to suggest unless you upload a sample file and mock up the desired output manually to show us what exactly you are trying to achieve. Would be great if you explain the logic behind the desired output in the file itself.
Oct 15 2020 11:20 PM
@doublekay2 Perhaps like in the attached workbook?
Oct 16 2020 03:37 PM
Yes, exactally what I was looking for.. Pretty sure I can copy from that now to get what I need. Thank you so much!!
Regards,
Kevin