Find Jobs
Hire Freelancers

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

$10-30 AUD

Completed
Posted almost 10 years ago

$10-30 AUD

Paid on delivery
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!
Project ID: 5905524

About the project

20 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 0 day
4.9 (167 reviews)
6.5
6.5
20 freelancers are bidding on average $22 AUD for this job
User Avatar
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 in 0 day
5.0 (799 reviews)
8.7
8.7
User Avatar
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 in 1 day
5.0 (175 reviews)
7.4
7.4
User Avatar
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 in 0 day
4.9 (292 reviews)
7.2
7.2
User Avatar
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 in 1 day
5.0 (197 reviews)
6.8
6.8
User Avatar
Dear employer. I can quickly create formulas to calculate as your requirement. Please consider my bid. Best regards.
$13 AUD in 0 day
5.0 (144 reviews)
6.8
6.8
User Avatar
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 in 1 day
4.9 (11 reviews)
5.3
5.3
User Avatar
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 in 1 day
4.8 (34 reviews)
5.2
5.2
User Avatar
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 in 0 day
5.0 (22 reviews)
4.8
4.8
User Avatar
Already preapred excell sheet , send me message so that i send you the excel file , its simple formula
$28 AUD in 1 day
5.0 (13 reviews)
4.5
4.5
User Avatar
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 in 1 day
4.7 (41 reviews)
4.5
4.5
User Avatar
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 in 0 day
4.8 (17 reviews)
4.1
4.1
User Avatar
i want to do your job sir try our job pls...................................................................................
$20 AUD in 1 day
4.9 (5 reviews)
1.2
1.2
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$17 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Sydney, Australia
4.8
34
Payment method verified
Member since Nov 24, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.