Find Jobs
Hire Freelancers

Fix Excel error

$2-8 USD / hour

Cancelled
Posted over 5 years ago

$2-8 USD / hour

Kindly check the excel file attached containing "Countif" function error. Could you fix it? I want to count certain criteria value in a range consisting of two or more columns defined with a Name in Name Manager.
Project ID: 18039703

About the project

36 proposals
Remote project
Active 6 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
36 freelancers are bidding on average $6 USD/hour for this job
User Avatar
This is Vibrant Webtech and I was glad to see that you're looking for help for project Fix Excel error. I've delivered more than 400 + projects in the last 5 years and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon.I have more than 5 year of experience in Excel, Visual Basic. Please ping me for more discussion.
$10 USD in 40 days
4.9 (319 reviews)
7.9
7.9
User Avatar
Excel expert!! I can fix it immediately. ZERO ERROR GUARANTEED!! Please read my ~400 reviews. I am here to impress you with my work.
$10 USD in 1 day
4.9 (280 reviews)
7.5
7.5
User Avatar
Hello Sir im excel VBA and formula Expert :) i can fix your "Countif" formula problem Sir please ping me and im free now to fix your problem now Thank You Galih
$5 USD in 40 days
4.9 (360 reviews)
7.2
7.2
User Avatar
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan
$4 USD in 40 days
5.0 (148 reviews)
6.5
6.5
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Ok. Sure. Willing to take up your project. Thank you, Regards.
$15 USD in 1 day
5.0 (107 reviews)
6.2
6.2
User Avatar
Hi what is correct value in G2? Is it 2? Should it count it if E2 is in list1 OR if E2 is in list2? I can do the project.
$11 USD in 1 day
5.0 (97 reviews)
6.1
6.1
User Avatar
Hi, I have checked the Excel file and verified that I am able to fix the formula. As I already have the solution, I can give it for $5 instead of the hourly rate. Thanks, Archana
$8 USD in 40 days
4.9 (89 reviews)
6.0
6.0
User Avatar
Hello there, as an expert in excel and VBA, i can help you to accurately correct your countif function as you have specified within 1 hour only. Please contact me and let us talk more about your project. Thanks
$10 USD in 1 day
5.0 (83 reviews)
5.8
5.8
User Avatar
Hi Good Day! A serious freelancer here! Is this done? if not, I can help you to complete this work in 1hr or less. I have a lots of available time for this work, but need to know the full requirements to assess how long would it take to complete every project. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!
$8 USD in 3 days
4.9 (35 reviews)
4.4
4.4
User Avatar
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself for this project. please contact with me. Thanks.
$6 USD in 40 days
4.7 (14 reviews)
4.4
4.4
User Avatar
greetings! I am interested and available to work on your project right. ### why make life so difficult, "sumifs" function is not to do such operation in your formulas. just use "sum" with "sumif" function will do. ### Hopefully you will award the project to me, Looking forward to hearing from you soon. Thanks & Best Regards, GS Anggara
$8 USD in 40 days
4.9 (26 reviews)
4.2
4.2
User Avatar
Dear Client, I can fix the "Countif" error in excel . I have excellent experience of Data entry, Web Scrapping,MS Office and Web Research for more than 4 Year’s. Never ends up until you are 100% satisfied with each and everything. I have 50+ WPM (Words Per Minute) with 100% Accuracy. I have worked on the similar projects before, so with my interpersonal skills and experience I would be happy to work for you. Best Wishes, Aishwarya Kumari
$2 USD in 40 days
5.0 (23 reviews)
3.7
3.7
User Avatar
Looking at your issue I think that it is because there is something wrong with your formula. The first approach was sound to create a formula that specifies two sets of criteria. What you can also do is look at sumproduct. However, if you can better explain what your end goal is I may be able to assist. If countifs do not work you can just write your own countif function.
$5 USD in 1 day
4.9 (9 reviews)
3.8
3.8
User Avatar
"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards "
$6 USD in 40 days
4.9 (17 reviews)
3.9
3.9
User Avatar
As an advanced excel user with valuable Financial / Analytical and Data Entry experience, I would be grateful if you would review my profile for the position advertised. Having worked at high levels within Finance, delivering accurate and timely reports to meet key deadlines has always been an essential part of the quality service I can offer. Also have vast experience in developing financial models via Excel (both basic and advanced).
$5 USD in 40 days
5.0 (3 reviews)
3.3
3.3
User Avatar
Hi there Could you please explain your purpose: What do you want to do below, 1 or 2? 1. Count cells that match multiple criteria (Both List1 criteria AND List2 criteria) 2. Count a name for all the lists by one by like one list. I can help you. I'm waiting your responce.
$2 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, if you want to count the number of values you have I your data set for specific columns, I don't think you need to use "Countif", I guess "count" should work. Please send me a message
$5 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Bachelor in Marine Transport Engineering with 2 years experience in transport and shipping planner. i have strong excell background that can fix your problem.
$4 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
The power of Microsoft Excel lies in its formulas. CCOUNTIFS function counts the number of cells in a range, that meets a single or multiple criteria. Let me show you my expertise in this regard.
$2 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i am having 3 year experience on excel for data mining.
$4 USD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of LEBANON
Beirut, Lebanon
5.0
42
Payment method verified
Member since Oct 8, 2014

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.