Calculate Excel data using SUMIF, SUMIFS functions and calculate conversion rate

$10-30 AUD

已完成

已发布

大约 10 年前

$10-30 AUD

货到付款

Do not waste our time with bids over $30. Make sure you read the below before bidding. If you bid over $30 we will see it as a Bot bid and we will flame you as a result. Hi all, We are trying to add data using SUMIF or SUMIFS function: 1) One column for the criteria has the date (ie. 5/05/2014) 2) 2nd column for the criteria has the sale STATUS (ie. Lost, Won or something else) 3) 3d column has the values to be added if the above 2 conditions are met We are also trying to calculate the conversion of Won items vs Lost items (ie. the ratio of WON vs LOST) for a given month so the ratio will change each month. We just need a simple formula to calculate both items above. We need the solution today. Good luck!

Data Processing

Excel

Mathematics

项目 ID: 5905524

关于此项目

20提案

远程项目

活跃10 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav

$30 AUD 在0天之内

4.9

(167条评论)

6.5

20威客以平均价$22 AUD来参与此工作竞价

@jaylancer43

Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have zero failed projects since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you award me the project. Thanks, Jay

$25 AUD 在0天之内

5.0

(799条评论)

8.7

@deepbluetech

Hi, I can surely provide you with the required two Excel formulas (using SUMIFS) within a day. Please confirm and provide sample data. Regards, Arul

$30 AUD 在1天之内

5.0

(175条评论)

7.4

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and I work with excel every day. I have much experience with formulas, and I can solve your project easily and quickly. Check my reviews. Greetings!

$13 AUD 在0天之内

4.9

(292条评论)

7.2

@priyal1997

Dear Sir/Madam. Just send me the existing data, first I will do it, if you are satisfied you can offer me the job. If you have any doubt pls visit my profile to see my reliability. I look forward to hearing from you soon. Best regards, Priyal

$30 AUD 在1天之内

5.0

(197条评论)

6.8

@hdlong66

Dear employer. I can quickly create formulas to calculate as your requirement. Please consider my bid. Best regards.

$13 AUD 在0天之内

5.0

(144条评论)

6.8

@ipewannasay

Hello, sir. I've tried to make soccer table based on match data. I used SUMIF, COUNTIF, VLOOKUP in it. I think your project and this soccer table has a lot in common. It will be done before the dawn. Hire me if you will, Thanks :)

$30 AUD 在1天之内

4.9

(11条评论)

5.3

@d2imatrix

Hi, Can do this in few minutes. You just need to tell me the cireteria for column A (date) and I can give you sum from Column C for all 'win' and all 'lost'...Also at the same time you would get ‘win sale/lost sale ‘ ratio. Kindly consider our bid and send us the file. Regards, d2imatrix

$15 AUD 在1天之内

4.8

(34条评论)

5.2

@ajaykumar0701

I am good at excel both in formulae and macros. I can do your task within the day. Please ping me if you are interested in it.

$20 AUD 在0天之内

5.0

(22条评论)

4.8

@alisabir2233

Already preapred excell sheet , send me message so that i send you the excel file , its simple formula

$28 AUD 在1天之内

5.0

(13条评论)

4.5

@ElaineTeo

I have skill work with Microsoft Excel program, I can build system with excel for make simply report with nice view, please view my portfolio, and I am graduated in accounting courses. In Microsoft Excel formulas I am confident in using Vlookup, If, And, Or, Sumif(s), Countif(s), and how to combine multiple f check ormulas and use Sort, Filters, Data Validation, Conditional Formatting, Pivot tables. If hired by you I will deliver my best work at high standard. I look forward to being hired by you for your jobs.

$20 AUD 在1天之内

4.7

(41条评论)

4.5

@Aan12

I can do it right now. All I need is some data or file to make the formula. If you are interested, send me a message so we can discuss the details. Thanks!

$15 AUD 在0天之内

4.8

(17条评论)

4.1

@bayramakkus

i want to do your job sir try our job pls...................................................................................

$20 AUD 在1天之内

4.9

(5条评论)

1.2

@srimanimadhumita

I am a housewife with some spare time at my end which I want to utilize effectively to generate some income on my own. I am a newbie but well versed with MS Excel and feel that I can be a right choice. I would request you to please give the opportunity to earn my credibility as a new freelancer. I can assure you of the quality and accuracy of the deliverables. Regards Madhumita

$25 AUD 在1天之内

0.0

(0条评论)

0.0

@muthunandini

I am very good at Excel. Can provide you the solution within 2-5 hours today once get the chance to look at the data.

$23 AUD 在1天之内

0.0

(0条评论)

0.0

@aqibzaman1314

I am new. But I need money. this is the only reason I am here. So u can understand no one willbe as dedicated as me. Thank You.

$15 AUD 在1天之内

0.0

(0条评论)

0.0

@dasdinesh86

A proposal has not yet been provided

$25 AUD 在1天之内

0.0

(0条评论)

0.0

@soumen84

Have extensive experience in advanced excel reporting and dashboarding, your requirements for finding out the conversion rate and conditionally summing the third column can be easily implemented in an hour. I am an experienced statistician, have worked in the analytics industry for 6 years and have a Master's degree in Business Analytics from a premier institute in India. Please award me the project asap so that I can provide you the solution at the earliest.

$14 AUD 在1天之内