Not sure how to do this??

%3CLINGO-SUB%20id%3D%22lingo-sub-1786518%22%20slang%3D%22en-US%22%3ENot%20sure%20how%20to%20do%20this%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1786518%22%20slang%3D%22en-US%22%3E%3CP%3EHello...%20I'm%20fluid%20in%20mid%20basic%20excel%20worksheets..%20I%20could%20not%20find%20the%20wording%20to%20search%20here%20for%20what%20I%20am%20trying%20to%20do%2C%20so%20figured%20Id%20just%20ask.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20budget%20worksheet...%20it%20goes%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E----Paid----%20%26nbsp%3B%26nbsp%3B%20---Account%20name----%20%26nbsp%3B%26nbsp%3B%20----due%20date----%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20---monthly%20payment----%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIts%20sorted%20by%20due%20date%20and%20there%20is%20a%20total%20at%20the%20bottom%20of%20all%20the%20monthly%20payments.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20check%20off%20under%20the%20paid%20column%20when%20its%20paid%20and%20I%20like%20the%20amount%20in%20the%20monthly%20payment%20column%20to%20then%20subtract%20that%20amount%20from%20the%20total%20at%20the%20bottom..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20this%20be%20done%3F%26nbsp%3B%20is%20it%20wicked%20difficult%20to%20do%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eany%20help%20with%20the%20info%20and%20formula%20would%20be%20appreciated%20and%20my%20budget%2Fcreditors%20appreciates%20it%20too.......%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20all%2C%3C%2FP%3E%3CP%3EKevin%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1786518%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1786778%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20sure%20how%20to%20do%20this%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1786778%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F834379%22%20target%3D%22_blank%22%3E%40doublekay2%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHard%20to%20suggest%20unless%20you%20upload%20a%20sample%20file%20and%20mock%20up%20the%20desired%20output%20manually%20to%20show%20us%20what%20exactly%20you%20are%20trying%20to%20achieve.%20Would%20be%20great%20if%20you%20explain%20the%20logic%20behind%20the%20desired%20output%20in%20the%20file%20itself.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1786895%22%20slang%3D%22en-US%22%3ERe%3A%20Not%20sure%20how%20to%20do%20this%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1786895%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F834379%22%20target%3D%22_blank%22%3E%40doublekay2%3C%2FA%3E%26nbsp%3BPerhaps%20like%20in%20the%20attached%20workbook%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

 

 

3 Replies
Highlighted

@doublekay2 

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.

Highlighted

@doublekay2 Perhaps like in the attached workbook?

Highlighted

@Riny_van_Eekelen 

 

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