Excel function expert needed for calculation

Kapalı İlan edilme: 2 yıl önce Teslim sırasında ödenir
Kapalı Teslim sırasında ödenir

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

Proje NO: #32668062

Proje hakkında

38 teklif Uzak proje Aktif 2 yıl önce

Bu iş için 38 freelancer ortalamada $22 teklif veriyor

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(213 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(88 Değerlendirme)
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 in 7 gün içinde
(2 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(7 Değerlendirme)
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,

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
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 Daha Fazla

$20 USD in 2 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$20 USD in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$20 USD in 7 gün içinde
(0 Değerlendirme)
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 in 15 gün içinde
(0 Değerlendirme)
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 in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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 Daha Fazla

$15 USD in 7 gün içinde
(1 Yorum)
0.0
dbauloni75

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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 in 7 gün içinde
(0 Değerlendirme)
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 in 7 gün içinde
(0 Değerlendirme)
0.0
infowhitepipit

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

$10 USD in 7 gün içinde
(0 Değerlendirme)
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 in 3 gün içinde
(0 Değerlendirme)
0.0