This is an Excel 2021 Microsoft Office 365 template called "bill paying checklist". I'm trying to figure out what function(s) I would use to automatically subtract the bill amount (for example, $50 in cell H4) from my Total Bills amount (for example, SUM(H4:H47) in cell H48, let's say $200) after I insert a checkmark in any cell in column K (by double-clicking). Value for checkmarks = 1. The result would indicate how much I still owe in cell J48; thus, if all bills are check-marked the result should be $0. Thank you!!
40 freelancers are bidding on average $22 for this job
Hi , i am a software engineer Excel/vba Expert, i read your job proposal , if you are seeking someone who can do the job in the best manner and a short time, i am your man, contact me. Regards.
Dear Employer, I'm ready to work on excel function project. I have strong experience in Visual Basic, Excel, Excel Macros. Could you initiate a chat so we can discuss on this. Thanks, Andrei
Hello, I am available now. can you please share the existing sheet with me so I can let you know the formula and working. Let’s have a discussion regarding this project in the inbox. Regards,