Fermé

Excel function expert needed for calculation

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!!

Compétences : Excel, Visual Basic, Excel Macros

Concernant l'employeur :
( 0 commentaires ) Yokosuka, Japan

Nº du projet : #32668062

40 freelances font une offre moyenne de 22 $ pour ce travail

(475 Commentaires)
8.4
(203 Commentaires)
8.1
(319 Commentaires)
7.4
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(144 Commentaires)
6.9
(184 Commentaires)
6.4
SShtv

Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(118 Commentaires)
6.5
(83 Commentaires)
5.8
(126 Commentaires)
6.1
(22 Commentaires)
5.3
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(47 Commentaires)
5.2
(66 Commentaires)
5.0
(37 Commentaires)
4.8
(7 Commentaires)
3.6
(12 Commentaires)
3.5
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(2 Commentaires)
3.7
(11 Commentaires)
3.6
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(6 Commentaires)
2.8
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
2.4
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,

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
1.7