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.
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.
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.
30 freelancers are bidding on average $4/hour for this job
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.
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
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 .