Excel function expert needed for calculation
$10-30 USD
Pagado a la entrega
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!!
Nº del proyecto: #32668062
Sobre el proyecto
38 freelancers están ofertando un promedio de $22 por este trabajo
Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Más
Hi, I am an Excel expert. I would love to help you to create function to automatically subtract the bill amount from total bills considering checkmarks and indicating the outstanding amount in cell J48. I can guide you Más
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
Hi. I am an excel expert.I want to assist you in this project and i am assuring you that you will get a professional output from me with all the necessary file formats. Please drop a message. I am waiting for your repl Más
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,
Hello, sir! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with data processing using Excel formula and VBA. All clients call me "Prince of Excel". I promise I Más
Hi, I am Analisa Ruhito, a freelance writer .I'm a hardworking and efficient fresher freelancer. This project piqued my interest because I felt that this was right down my alley. My understanding of the work is what ma Más
I am interested to work with you. I have good experience in ms word, Excel and power point. I am looking forward to your positive response.
Hi, I'm Diorgelis Franco. I am interested in your job offer. For 6 years I have been performing the functions you want them to perform. I would like to be able to be a team with you and benefit from the work.
Hi, I am an expert in Excel and VBA. I have done several projects in which I have done any task using programming in VBA. I can do it quickly and will provide you with quality and fast work. Can we discuss all your nee Más
I use excel for pay processing so am expert in calculation with formulas. Will do the job for you as requested
Hello sir, I am a programmer, excel VBA developper, and an electrical engineer. This job is very easy for me and in fact, I've already figured out the solution and can modify the sheet for you in 15 minutes. Because I Más
Hola entiendo tu inquietud y puedo ayudarte a solucionar el problema realmente no es algo difícil pero si se pudiese hacer algo que sea manejable que a futuro te resulte automático contactame
You could write a macro to display the check mark. Then in the column you want to add, you could use the sumif function on cells in the check mark column that are not empty
Hello I can do this task. I have experience with VBA macro in Excel. Please send me the details and I will start immediately. Regards Rahim