Find Jobs
Hire Freelancers

Create formula to count cells by colour in Excel spreadsheet

$10-30 USD

I përfunduar
Postuar almost 5 years ago

$10-30 USD

Paguhet në dorëzim
I have a spreadsheet (attached). I need totals to be generated by counting the number of cells of certain colour. i.e. if 10 cells are green, then it would display the number 10 in the 'total of green cells' field. HERE ARE A FULL SET OF TASKS TO COMPLETE: Cell B4: Needs to display the total number of GREEN cells in column E Cell B5: Needs to display the total number of ORANGE cells in column E Cell B6: Needs to display the total number of RED cells in column E Cell D4: Needs to display the total sum recorded in column D (but only the cells which have GREEN next to them in column E) Cell D5: Needs to display the total sum recorded in column D (but only the cells which have ORANGE next to them in column E) Cell D6: Needs to display the total sum recorded in column D (but only the cells which have RED next to them in column E) Make a pie chart to represent the 3 sets of data collected in cells B4, B5 and B6 and place next to the table.
ID e Projektit: 19648546

Rreth projektit

3 propozime
Projekt në distancë
Aktive 5 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
$30 USD në 1 ditë
4,9 (275 përshtypje)
7,1
7,1
3 freelancers are bidding on average $33 USD for this job
Avatari i Përdoruesit
Hello. I have read your Bid carefully. I like VB & VBA very much. Because It was the first program I learned. Of course, now I have very high skills, many programming languages, a lot of technology and 3D technology, but VB & VBA is still my hobby. I have enough experiences as a Programmer and Designer at the top. I enjoy coding, and I value my client's trust and I commit myself to any job, taking full responsibility in completing projects on time. I believe communication is very important, and you can communicate with me at any time. I think our trust is very important. If you hire me, I will do my best for you. Let's meet and discuss more. Thanks.
$50 USD në 2 ditë
4,9 (3 përshtypje)
2,8
2,8
Avatari i Përdoruesit
Dear Hiring Manager! I have reviewed your requirements for your preconceived project. I'm interested in your project. I have 3 Years experience in Data Entry, Data scraping, Lead generation & Web research. I'm available to start work immediately. It is my strong belief that you will be a very happy client after receiving the product. As such, do not hesitate to award me the task ahead. Hope to hear from you soon. Have a good day! Kindly Regards, Hassan
$20 USD në 1 ditë
4,5 (7 përshtypje)
2,5
2,5

Rreth klientit

Flamuri i UNITED KINGDOM
Maidstone, United Kingdom
5,0
438
Mënyra e pagesës u verifikua
Anëtar që nga sht 24, 2013

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.