Find Jobs
Hire Freelancers

Do some Excel Work

$10-30 USD

已完成
已发布超过 8 年前

$10-30 USD

货到付款
I need an Excel expert to do a simple formula. Open the Included Excel file , go to 2nd tab, if it doesn't open to that tab automatically. I need you to use a formula to calculate total sales in column B, which is sales by zip code, for all zips within each unique city and then put that number in column E, the column labeled "total sales by city". So for the first city, named "Abilene, Texas", there are five zip codes for that city with sales figures in column B. The totals for those five zips that apply to Abilene are shown below. 20 #N/A ABILENE, TX 13 #N/A ABILENE, TX 4 #N/A ABILENE, TX 3 #N/A ABILENE, TX 1 #N/A ABILENE, TX So the total is 41 sales for Abilene. That figure will go in the first box for Abilene in column E and the other four cells below it in that column will be left blank as shown in the spreadsheet. Please complete the next two cities and post that file in your message so i know you understand what needs to be done. I will award the project to the qualified freelancer that reads this post and posts the example i am requesting. thank you.
项目 ID: 8594644

关于此项目

47提案
远程项目
活跃8 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
REV: Ok, thanks for the attachment file, please review the file at: [login to view URL] I've done it until row 266: ALLENTOWN, PA I truncated the rest of the rows and removed the 1st tab to make the file smaller (just for this sample). I can send you the file max 1 hour after you award me the project. Previous msg: I could have sent you the file if you attached it in the project description (I don't see any file attached). Could you please send me the file so I can understand and give you my feedback with the solution? Do you need the automation (macro/vba codes) or just the result? I am sure I can finish it in a couple of hours. Let me know, Best Wishes, Daniel
$15 USD 在1天之内
5.0 (146条评论)
6.3
6.3
47威客以平均价$24 USD来参与此工作竞价
用户头像
Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?
$30 USD 在0天之内
4.9 (229条评论)
6.4
6.4
用户头像
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely prameswara
$15 USD 在1天之内
5.0 (142条评论)
5.8
5.8
用户头像
Hello, I am willing to give sample work for your review but there is no attachment. Would you share the missing file, please? Thank you and Best regards, Hoang
$30 USD 在1天之内
5.0 (75条评论)
5.8
5.8
用户头像
Hi, I can confirm you that I will be able to complete your project with the highest quality and accuracy. No need to pay me anything if you are not satisfied with my work. I will be more than happy if I get the opportunity to work with you on this project. Please feel free to check my reviews here (https://www.freelancer.com/u/safiqulislam67.html). Best regards, Safiqul Islam
$30 USD 在1天之内
5.0 (73条评论)
5.8
5.8
用户头像
Hello! I'm an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$25 USD 在1天之内
5.0 (54条评论)
5.6
5.6
用户头像
Formula: Please insert this in cell E3 then copy and paste down till E21260. You will get your requirement: =IF(D3=D2,"",SUMIF($D$2:$D$21261,D3,$B$2:$B$21261)) Thanks Update: Okay, got the file. Now please send me chat so that I can send you the file because I cannot attach it here. Thanks ____________________ Hi! I could not find any attached file. Please send me the file. Thanks .
$15 USD 在1天之内
4.9 (68条评论)
4.7
4.7
用户头像
Hello, My name is Reju, and I would like to be considered for you project. I have been using freelancer.com for more than 2 years, successfully completing over 19 projects during this time. You can see from my profile (https://www.freelancer.com/u/mdreju.html) that I have received excellent feedback so far. My average rating is now 5 out of 5. I always work with honesty, dedication and punctuality to make sure that I submit quality work in time for your deadlines. Previously completed projects include; data entry, data scrapping, data mining, data structures, data analytics, internet research, excel and product uploading. This experience would help to make me the ideal choice for your next project. If you have any questions about my work, please get in contact. Thank you, Md Reju
$30 USD 在1天之内
5.0 (17条评论)
4.3
4.3
用户头像
Hi, I have updated the next two cities sum according to your requirement. I will use excel functions to derive the first and last occurrence of the city name and from that I will calculate the sum in the first occurrence. Please confirm me I will start the work immediately 20 #N/A ABILENE, TX 41 13 #N/A ABILENE, TX 4 #N/A ABILENE, TX 3 #N/A ABILENE, TX 1 #N/A ABILENE, TX 3 Growth ABINGDON, IL 3 2 Managed ABINGDON, MD 2 6 Managed ABINGDON, VA 8 2 Managed ABINGDON, VA 5 Growth ABITA SPRINGS, LA 5 3 Growth ABRAMS, WI 3 2 Managed ABSECON, NJ 3 1 Managed ABSECON, NJ 17 Managed/Closed ACAMPO, CA 17 Regards, Rajesh. -------------------------- Hi, I am interested to work on your project. Looks like the spreadsheet in attachment is missing. Could you please share the sheet to have more understanding? After reading the description I hope below format would be your requirement. I will use excel functions to retrieve the values. 20 #N/A ABILENE TX 41 13 #N/A ABILENE TX 4 #N/A ABILENE TX 3 #N/A ABILENE TX 1 #N/A ABILENE TX 20 #N/A Houston TX 61 13 #N/A Houston TX 24 #N/A Houston TX 3 #N/A Houston TX 1 #N/A Houston TX 10 #N/A Dallas TX 80 13 #N/A Dallas TX 53 #N/A Dallas TX 3 #N/A Dallas TX 1 #N/A Dallas TX Please provide the sheet and other details to start the work. Regards, Rajesh.
$30 USD 在1天之内
5.0 (4条评论)
4.3
4.3
用户头像
there is no attachement but anyway i can do it in 20 minutes I am mostly online. Just drop me a message so that we can discuss further about pricing and job details.
$24 USD 在1天之内
5.0 (31条评论)
4.2
4.2
用户头像
I have the expertise in Excel and can do the assigned task. However there is no attachment to give you a sample of your request. Update : Instead of attaching the file, i have pasted the results here : 6 Managed ABINGDON, VA 8 2 Managed ABINGDON, VA 2 Managed ABSECON, NJ 3 1 Managed ABSECON, NJ
$30 USD 在1天之内
4.9 (20条评论)
4.1
4.1
用户头像
contact me sir i can do this.............................................................................
$15 USD 在0天之内
4.9 (15条评论)
3.9
3.9
用户头像
There is no excel attached to work on. I can work on this and provide you the completed work as per the requirements. I am a certified MS excel expert Freelancer with 3 years of experience.
$30 USD 在1天之内
4.8 (8条评论)
2.8
2.8
用户头像
Hello, I am very interesting to your project & placed bid for your consideration. with 3year+ experienced in excel coder & formulas I am very confident that i will deliver good result as per your requirement on time. Attachment file can not found, could you repost so I can attach the result for your review. Looking forward to your attachment. Thank & Regards, gsanggara
$15 USD 在0天之内
5.0 (4条评论)
2.1
2.1
用户头像
Hi, i'm new on this site, but i'm very skilled on excel and vba. I've already implemented some simple project, you can see their feedbacks. I'd like to work on your project; i don't see any file attached to it, so, please, may you kindly send i t to me? Hope to be contacted, best regards Andrea
$15 USD 在0天之内
5.0 (6条评论)
1.2
1.2
用户头像
There is no spreadsheet attached to the posting. I'm sure I can provide the spreadsheet to your request. Thanks
$25 USD 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
$25 USD 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
$26 USD 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
i am good in excel, can do the work all the day. can complete task as soon as possible. Continuous projects can be handled with good quality.
$25 USD 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
I will complete the work on time with assured quality and the required production. I have prior working experience for data entry.
$25 USD 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
I am confident I can complete this project quickly and efficiency for you. Happy to provide an example of the required formula if you can provide the sample Excel file.
$30 USD 在1天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
Orange, United States
5.0
112
付款方式已验证
会员自1月 13, 2009起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。