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

Ταυτότητα εργασίας: 5905524

Σχετικά με την εργασία

20 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 10 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο 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 freelancers δίνουν μια μέση προσφορά $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 ημέρα