Completed

excel task -- 2

I have two columns in excel, A and B.

In column A the cells are either blank or a number e.g. 0, 1 or 999

In column B the cells are either blank or contain a number 1,2,3,4,5,6 or 7

The numbers in column B cells represent a category e.g. 1 = milk, 2 = bread, 3 = cheese etc. The cells in column A represent represent the number of category items for each row.

e.g.

A1 = 1 and B1 = 1

A200 = 99 and B200 = 3

Therefore row 1 shows there is 1 milk, and row 200 shows there are 99 cheese.

TASK:

Find the total number of items in the spreadsheet for each category (there are 7 categories).The solution shall be re-usable i.e. an excel formula so I can re-use.

Skills: Excel

See more: odbc driver excel iseries add use, switch excel vb6 app use open sheet, sorting columns numbers macros excel, automate some task -- 2, automate some task 2, do some excel work -- 2, do some excel work -2, Do some excel work 2, do some excel work-2, excel project 2/2, excel work-2, ielts writing task 2, management task 2, repair excel file 2, small java task -- 2, small java task 2, academic writing task 2, acadmic ielts writing task 2, download academic writing task 2

About the Employer:
( 10 reviews ) Talbingo, Australia

Project ID: #20928257

Awarded to:

shahinrahimi

hi there, I'm interested in your project, I can help you with finding the total number of items in the spreadsheet for each category in a fast way using VBA or formulas I have rich experience in excel (advanced formula More

$5 AUD / hour
(30 Reviews)
4.3

29 freelancers are bidding on average $4/hour for this job

olaideejiwole

Hello sir/ma, I'm interested in taking this task up for you. I'm a professional and also have good command over MS Excel especially pivot table, charts, advanced formulas, formatting, Excel VBA, R Programming Language More

$5 AUD / hour
(6 Reviews)
3.5
fattahaabdul

I can do excel task for you. I have 8+ years of experience in excel. I assure you that i will give 100% quality work. Let us discuss and proceed further in chat. I am online. Please reply.

$8 AUD / hour
(3 Reviews)
3.4
nzadeh

Greetings, I've read your project description. I am an expert in Excel. I can do your project with high quality and deliver you as well as you wish. Hope to hear from you. Regards

$5 AUD / hour
(3 Reviews)
2.2
abhaysony20

Hi There, Greetings from Rakhi !!!!!!!!!!!!!!!! I carefully read your requirements and as a sprout freelancer on this platform I will do your work with full dedication and quality. I know my quality will give me more More

$2 AUD / hour
(6 Reviews)
2.0
RachitGroup

Hello, I read through the job details of your project and I am absolutely sure that I can do this project very well, I have more than 5 years of experience in it. I Provide - - 24x7 Services to My Clients(The Reason More

$5 AUD / hour
(3 Reviews)
1.6
i4ConsultantDev

Hi, Thanks for the posting. I am writing this after reviewed your project description. I am interested in your project and Kindly drop a message so we can discuss. I have Proficient experience in MS Office Tools & Dat More

$2 AUD / hour
(1 Review)
1.2
Meanstack1

I will be happy to help you with this project. I'm an experienced data handler and can work quick and accurate. I'll create new data files, update old files and manage your excel records, PDF files and many more. Feel More

$3 AUD / hour
(0 Reviews)
0.0
khan947

I HAVE SUFFICIENT KNOWLEDGE OF EXCEL AND I CAN WORK ON THIS EASILY . I AM VERY RESPONSIBLE PERSON TO DO ANY WORK

$5 AUD / hour
(0 Reviews)
0.0
Ogutuemily

I am an expert in excel and I can handle this task pretty well. Feel free to contact me about the role.

$5 AUD / hour
(0 Reviews)
0.0
JaymarieSalera

hello this is jaymarie an IT expert .i've been using excel for my last work .besides this kind of project like its very interested for me so let me be one of your progressing projects thank you so much .

$4 AUD / hour
(0 Reviews)
0.0
Darjan85

There is nothing I cannot do in this program. I have over 5 years of experience working in Excel.

$5 AUD / hour
(0 Reviews)
0.0
jonajohanna88

Hello, I'm Yohanna. I am interested in this job offer. I already saw the attached file, I believe I can help you with this job. Thank you for your time.

$6 AUD / hour
(0 Reviews)
0.0
punyaushak

Good at Microsoft excel and word. Can clearly understand the requirement of project and try to give my best. Can work 40 hrs/week.

$6 AUD / hour
(0 Reviews)
0.0
samreenshahbazze

I work on Excel Database Relevant Skills and Experience I work on Excel and Database is my field

$5 AUD / hour
(0 Reviews)
0.0
velpulasampath50

I had experience in excel spreadsheet for more than three years and I could type in a maximum speed so I think I am suitable for this job.

$5 AUD / hour
(0 Reviews)
0.0
rahuld2009

Respected Sir, I read your project details. I'm interested for this project. I'm from Statistics background. I have great knowledge about Excel. I request to you to give me this project. I'll give you project with 10 More

$6 AUD / hour
(0 Reviews)
0.0
ryka86

I’m good with excel. Let me help you to put the correct formula that you can use in the future. Thanks

$6 AUD / hour
(0 Reviews)
0.0
asiriweerakoon

Dear sir/madam, My name is Asiri Weerakoon from Sri Lanka. I Studied your project, understood all your requirements and therefore I am bidding for it. I am an experienced Accounts assistant, with a creative mind tha More

$2 AUD / hour
(0 Reviews)
0.0
nandhunava

Dear Hiring Manager, I'm available to work full or part-time and can start immediately. As of now I am available and can start anytime, you can expect from me the best output and being punctual. I've done a lot rela More

$4 AUD / hour
(0 Reviews)
0.0
mgoswami5904

Hii, I have eight month experience in exce and I am interested in your project. I am very honest about my work and I can finish your work in the given time.

$4 AUD / hour
(0 Reviews)
0.0