Excel function expert needed for calculation

終了済み 投稿 2年前 着払い
終了済み 着払い

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 Macros

プロジェクトID: #32668062

プロジェクトについて

38個の提案 リモートプロジェクト アクティブ 2年前

38人のフリーランサーが、平均$22 で、この仕事に入札しています。

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 もっと

$20 USD 1日以内
(213件のレビュー)
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 もっと

$14 USD 1日以内
(88件のレビュー)
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 7日以内
(2件のレビュー)
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 1日以内
(3件のレビュー)
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 もっと

$20 USD 1日以内
(7件のレビュー)
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 1日以内
(レビュー1件)
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 もっと

$30 USD 1日以内
(3件のレビュー)
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 もっと

$20 USD 2日以内
(0件のレビュー)
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 もっと

$20 USD 7日以内
(0件のレビュー)
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 もっと

$20 USD 7日以内
(0件のレビュー)
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 15日以内
(0件のレビュー)
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 7日以内
(0件のレビュー)
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 もっと

$10 USD 1日以内
(0件のレビュー)
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 もっと

$15 USD 7日以内
(レビュー1件)
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 1日以内
(0件のレビュー)
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 もっと

$10 USD 1日以内
(0件のレビュー)
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 7日以内
(0件のレビュー)
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 7日以内
(0件のレビュー)
0.0
infowhitepipit

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

$10 USD 7日以内
(0件のレビュー)
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 3日以内
(0件のレビュー)
0.0