Excel function expert needed for calculation

Cerrado Publicado hace 2 años Pagado a la entrega
Cerrado 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!!

Excel Visual Basic Excel Macros

Nº del proyecto: #32668062

Sobre el proyecto

38 propuestas Proyecto remoto Activo hace 2 años

38 freelancers están ofertando un promedio de $22 por este trabajo

daniyal3214

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

$20 USD en 1 día
(213 comentarios)
7.2
hamidr2020

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

$14 USD en 1 día
(88 comentarios)
6.1
benrached46

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.

$20 USD en 7 días
(2 comentarios)
3.7
AndreiBird

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

$21 USD en 1 día
(3 comentarios)
3.8
anmolmakkar666

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

$20 USD en 1 día
(7 comentarios)
2.9
padhiar37

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,

$20 USD en 1 día
(1 comentario)
2.0
andylawsonstatz

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

$30 USD en 1 día
(3 comentarios)
1.7
LashkoA97

Hi client! How Are You ? I have checked your description carefully. I am sure I have rich experience for your project. I would love to serve you as much as I can. I can finish your project with high quality on time & o Más

$20 USD en 2 días
(0 comentarios)
0.0
Analisarht0

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

$20 USD en 7 días
(0 comentarios)
0.0
jpaul447

Hello I'm JP Galimba. I'm from the Philippines. My prevoius job is a Medical Representative working in various hospitals in my town and talking with clients and Doctors every day. I am a detail-oriented, honest, and ha Más

$20 USD en 7 días
(0 comentarios)
0.0
mhuddin82

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.

$25 USD en 15 días
(0 comentarios)
0.0
diorgelis70

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.

$20 USD en 7 días
(0 comentarios)
0.0
sbala26

Hi I have gone through the excel sheet and understand your requirement to calculate the remaining amount to be paid in the " Bill Paying Checklist" template. I can make the column to show the net amount you owe. I am Más

$10 USD en 1 día
(0 comentarios)
0.0
trhbehzade

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

$15 USD en 7 días
(1 comentario)
0.0
dbauloni75

I use excel for pay processing so am expert in calculation with formulas. Will do the job for you as requested

$20 USD en 1 día
(0 comentarios)
0.0
mohammadfalahat

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

$10 USD en 1 día
(0 comentarios)
0.0
jmonsalve31

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

$20 USD en 7 días
(0 comentarios)
0.0
charliemartindz

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

$20 USD en 7 días
(0 comentarios)
0.0
infowhitepipit

HI, Please share the file with me, and it'll be done immediately. Thank you, Dina

$10 USD en 7 días
(0 comentarios)
0.0
mamedovr

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

$10 USD en 3 días
(0 comentarios)
0.0