Find Jobs
Hire Freelancers

I would like to hire an Excel Expert

$10-30 AUD

Completed
Posted over 7 years ago

$10-30 AUD

Paid on delivery
I am trying SUM IF the month and year are the same the criteria and a code is also the same using an array formula. I can get the formulas to work independently but not when I combine them. THESE WORK: =SUM(IF((MONTH(Income!$A$3:$A$10000)=MONTH($A3))*(YEAR(Income!$A$3:$A$10000)=YEAR($A3)),Income!$C$3:$C$10000)) =SUMIF(Income!$D$3:$D$10000,"="&$C$2,Income!$C$3:$C$10000) THIS DOES NOT: NO =SUMIFS(Income!$C$3:$C$10000,Income!$D$3:$D$10000,"="&$C$2,MONTH(Income!$A$3:$A$10000),"="&MONTH($A3),YEAR(Income!$A$3:$A$10000),"="&YEAR($A3))
Project ID: 12290332

About the project

14 proposals
Remote project
Active 7 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
Hello, I am an excel expert. I can solve your problem in couple of minutes after you share the file. Hope to work with you.
$10 AUD in 1 day
5.0 (2 reviews)
1.1
1.1
14 freelancers are bidding on average $23 AUD for this job
User Avatar
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
$30 AUD in 1 day
4.8 (203 reviews)
6.7
6.7
User Avatar
Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. I have excellent knowledge and experience of Using Advanced Formulas. I can fixed and explain this issue. I have done mostly this type of job where data manipulation is required. Please check my portfolio to see my work. Ready to start please reply soon. Thanks, Virendra
$30 AUD in 1 day
4.9 (30 reviews)
4.1
4.1
User Avatar
Hi, I’m Anik. I’m a professional in freelancing work. I’m working in these fields for a long term. I'm very expert in MS office (ms word,excel & powerpoint), google sheets, PDF & Photoshop. I'm also professional in web research & data scraping work & I’m very familiar and experienced with this kind project. I'm optimistic enough that i can do your job well & can deliver my work in budget time. My English level is always in a satisfactory possession. If you want a reliable person for your administrative work then i’m very willing to submit me as a right person for you project. My Typing Speed is 50w/min I hope you will call me to take a interview. I,m very willing to work with you for a long term basis. Thanks & regards Anik Kanti Dey
$25 AUD in 1 day
5.0 (8 reviews)
1.7
1.7
User Avatar
Hey, Can send a sample for the data? I want to test it and show you that is working. About me: I recently finished a tool that was looping trough the excels files from a folder in order to import and process them based on some configurable parameters. I would like to mention that I'm more interested in the quality of the deliverable and customer satisfaction in order to get a good review than the money. Therefore we can negotiate to get to the amount that you're comfortable with! I invite you to discuss further the solutions that we will implement in your project. Best regards, Marius Avram
$30 AUD in 0 day
5.0 (6 reviews)
1.8
1.8
User Avatar
Hi, I will work as per your direction and will complete the project before deadline with 100% accuracy. I want to show you sample before you award me. So that you can judge me. I am waiting for your response to start working. Thanks
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am Data Entry/Data Processing Expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer happy without adding additional charges. If you are looking for data entry or search work, I am the Right person for you. available 24-7. a trusted Freelancer
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there! I am perfect for this role for your project as I come with an extensive experience in various areas of IT. Content writing, blogging, web-development, MS Excel / Word, Data Entry Applications, Web crawling & research, Image editing / designing, Wordpress; these are just some of the areas of my expertise. I also come with a bevy of necessary resources required to complete this project qualitatively & efficiently. As I comply with all the requirements mentioned on your post, I am an adept candidate for the project. Why choose me? • Consistent & Accurate • I prefer to work qualitatively rather than quantitatively • I leave no margin for error • I work on a countdown mode • I deliver projects right on time • All projects under go QA checks prior to submission • Post completion assistance always provided • Plagiarism-free content • Secure & fast internet connection with an independent standby broadband connection What do I need from you? • Complete project details • List of criteria which need to be adhered to • Any sample details for comparison Payment Terms: • As per project requirements • Payment accepted only via Freelancer I shall look forward to working with you & am confident of exceeding your expectations. Many Thanks & Warm Regards, Suraj Shah
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Client, Greeting of the day ahead !!! Thanks for providing us opportunity to place bid over the project and communicate with you. I am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned .I have checked your requirements.i have right skills to work on this assignmentWe find our expertise, skills and capabilities are perfectly blends with your project requirements because we have already worked on many projects. You'll love the whole layout, interface design , cross-browser compatibility and mobile-device-friendly interfaces that we design Our team has created over dozen of windows, and web based appliations iPhone/iPad games and apps, and over 10 Windows and Linux server APIs and security tools Don't waste any more time in your development We take care of all these things for you . Advanced custom coding for our clients. Anytime. can u provide your email or sky-pe etc for further discussion about the project. plz add me to discus I am ready to discuss with you Looking forward to hear from you. with best Regards
$23 AUD in 6 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Loganholme, Australia
5.0
1
Payment method verified
Member since Dec 6, 2016

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.