Find Jobs
Hire Freelancers

Excel project - tally & sum amounts by calendar month

£10-20 GBP

Completed
Posted over 4 years ago

£10-20 GBP

Paid on delivery
Simple excel project. We have 2 lists in separate tabs in excel. Each list has a date in the first column and a monetary amount in the second column. We would a table completed (see respective tabs) that adds up the sum total of the entries per calendar month. List A has 1608 entries and List B has 890 entries. The first entry for list A in the table should therefore be £13,457.63 (the sum of the entries from list A that are from January 2015.
Project ID: 23383269

About the project

23 proposals
Remote project
Active 4 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
Hi There! I've already completed this task. The trick in doing this is using SUMIF and having some text formatting. See screenshot result of the table A here: [login to view URL] Let me know in the chat if you have questions. Thanks!
£15 GBP in 1 day
4.9 (6 reviews)
2.9
2.9
23 freelancers are bidding on average £14 GBP for this job
User Avatar
Hi, I read your project carefully and completely understand it "I am certified in Microsoft Office, Microsoft Excel, Word and Access. I have good command over data management in Excel Dashboard, Spreadsheet as well as in Microsoft Access Database. I have 15 years’ experience to handle Databases as well as I have completed many projects and our company's profile feedback section is showing our abilities and client recommendations. So, you can Trust us for a Best output with complete satisfaction. Your work will be deliver on time and I will provide you the unlimited revision of your work after checking when you completely satisfied then you can release money. Because your satisfaction is my first priority. You can see a great level of communication and customer support. Looking forward for great business deal and good start for future relations. "
£17 GBP in 1 day
4.9 (251 reviews)
7.3
7.3
User Avatar
its simple task,u just need sum of each month in table a and table b sheet i can do right now 2nd entry in table a would be for 2/1/2015=8398.90
£10 GBP in 1 day
4.9 (536 reviews)
7.3
7.3
User Avatar
Hello, this is very simple, if you are interested in working with me, please message me. I believe i can create this sum formulas for you in less than 15 minutes. I've done similar thing many times before. Thanks, Milan
£14 GBP in 1 day
5.0 (530 reviews)
7.0
7.0
User Avatar
Hello there. I checked your project description (complete excel tables in 2 sheets).I can do your project in less than 24 hours according to your description with full delivery and without error. I would also complete your project with the highest precision and quality. I have extensive experience in excel, data entry and data processing.
£30 GBP in 2 days
4.9 (129 reviews)
6.1
6.1
User Avatar
Hello, I am willing to do your project and ready to start work. Please response. Thanks Ramjan
£13 GBP in 1 day
4.9 (96 reviews)
5.1
5.1
User Avatar
Hii I would like to work for you on this project in low budget and in good time. I have enough experience of this field. We can start work as soon as possible. Thank You
£20 GBP in 1 day
4.9 (22 reviews)
4.1
4.1
User Avatar
Hi Sir I am interested in your project Sir after reading the project description I am offering my services to complete the project. Sir I think that I am the right person for which you are looking for your project. Sir I completed 80 plus project successfully. Sir I have all those skills which is needed to complete this projects. Sir lets discuss the project further.
£10 GBP in 1 day
4.6 (45 reviews)
4.1
4.1
User Avatar
Hi there. I have read and understood every requirement of your project. I am proficient in data processing, excel, VBA with 5 years of experience. Hence, I am interested in working on your project. I am sure to deliver 100% quality work in one day only. I look forward to hearing from you. Thanks in advance.
£15 GBP in 1 day
4.7 (17 reviews)
3.7
3.7
User Avatar
I Would like to help you Sir with that task. If i am understanding correct, then the second entry/value should be (8,398.9) am i right !? Please find my bid. Thank you.
£12 GBP in 1 day
5.0 (13 reviews)
3.2
3.2
User Avatar
Hello, I'm ready to help you to tally and sum the ammounts as I have experience in Accounting and Excel.. Thank you.
£10 GBP in 1 day
5.0 (3 reviews)
2.3
2.3
User Avatar
This is a simple Excel project and can be delivered within an hour. You can contact as I already did it.
£15 GBP in 1 day
5.0 (1 review)
0.7
0.7
User Avatar
Hi Sir, I have good experience in in Excel and Data Entry. I assure you quality work. Looking forward to start working with you. Thanks, Muhammad A.
£13 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a fast learner, hard worker, result-oriented and trustworthy - a perfect addition to any team of professionals! I perform extremely well under pressure and I'm comfortable working with tight deadlines. Always ready to learn something new and to upgrade my skills. •Click on the ''Hire me'' , I LOVE working with long-term clients. Also, I am ready to work in your time zone. :) I have experience in the following: Offline/Online Data Entry Jobs Web Research Jobs LinkedIn Data Collection Companies Emails Research Contacts and Email Research for Marketing and Business Purposes Email Marketing Lists Instagram Data Collection Microsoft Excel Data Cleaning PDF to Excel/CSV Conversion Copy Paste Tasks Data Capturing from Websites Data Collection Data Mining Mailing Lists Creation Business Cards into Ms Excel Typing Work
£10 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
hi sir i am ready for your job I have an experience in this field for two years chat me about details
£15 GBP in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Friend I have very experince with datasheet and I'm able to make this work. Contact me, please. Thanks I'm Frelancer in WebDev, please give me an opportunity.
£10 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
saya siap bekerja sesuai dengan yang anda harapkan, jika saya diterima, saya akan bekerja dengan sungguh-sungguh.
£13 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have already done your work as per your requirement. Kindly check it. I am sure you will find it accurate and up to the mark. Thanks a lot in advance if you select my bid.
£10 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi sir/madam I can do to this work please tell how to get money for the after work. I will do this work correctly.
£15 GBP in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Staverton, United Kingdom
5.0
3
Payment method verified
Member since Aug 15, 2018

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.