In Progress

Excel formular - Sum up multiple data in multiple cells & record down the order no.

Like the photo shown, i need to do a homework about summing up product quantity. This formula is bestly based on Excel. It is a $30 project.

In sheet 1,

A column is Order no. (A2 = 0001, A3 = 0002, A4 = 0003..etc). Products are free to order, order 0002 can contains some model where 0003 have.

Start from Y2, product information recorded in below absolute format and repeat till end of the order:

Model Product Qty Price

Model no. are started with "PD-" , "T-" , "Set-" , "A" or "S-", where repeat in every 4 columns. Product full name start with model no.

I need to add a Sheet 2, sum up all the corresponding data in Sheet 1 and sort in below format:

Eg.

Model Qty Corresponding Order no.

PD-0553 4 0001, 0003

PD-0554 3 0001

Thanks,

CC

Sheet 2 should be in excel2.JPG format.

Eg. For Model PD-0553, there are 2 ppl ordered.
Order no.0001 takes 2 and no.0003 takes 2, so tatally 4pcs need for procurement.

Skills: Excel, Visual Basic

See more: sum cells excel, sum columns excel, excel formular, sum multiple columns excel, sum multiple sheets excel, sum time excel, sum data excel, sum sheets excel, excel sum multiple, add multiple cells excel, add multiple columns excel, excel sum columns, vb6 excel sum, sum multiple cells, sum product formular, excel sum product, formulare excel, sum multiple cells excel, sum cells vba, excel sum data, sum multiple columns excel 2007, summing excel, sum multiple excel, multiple data cell excel, sum sheets

About the Employer:
( 52 reviews ) USA, United States

Project ID: #236015

Awarded to:

Icebear951

Please check PM for further details

$30 USD in 0 days
(6 Reviews)
3.3

19 freelancers are bidding on average $30 for this job

expertMan

ready for your work.

$30 USD in 0 days
(17 Reviews)
5.6
imranamin

Excel Expert at your service. Kindly see PM for details

$30 USD in 1 day
(31 Reviews)
5.4
best4best

Please see PMB.

$30 USD in 1 day
(57 Reviews)
5.0
VLADNOVA

Sir - You may consider it's done already. Please see PM for details.

$30 USD in 1 day
(9 Reviews)
4.2
johnsinit

Dear CC! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

$30 USD in 2 days
(16 Reviews)
4.2
msoftsolution

Hi please see pmb

$30 USD in 1 day
(1 Review)
2.7
Prestohuan

My only purpose is to offer your my good service and get your good reviews, thanks for your attention.

$30 USD in 0 days
(1 Review)
2.0
cykwong

I have plenty of experience of it.

$30 USD in 1 day
(1 Review)
1.6
krish797

Sir or Madam, Please Contact me. Thanking you, [url removed, login to view] Kumar

$30 USD in 1 day
(1 Review)
1.4
kmohan1962

Hello; I'm right away ready for a fast turnaround within hours for as low as $10. REgards.

$30 USD in 1 day
(3 Reviews)
0.9
kapthirty

Hi, please PM

$30 USD in 1 day
(0 Reviews)
0.0
Arotsotra

I am ready to carry out this project, but can you give me an example in MsOffice Excel to have more information.

$30 USD in 1 day
(0 Reviews)
0.0
soumenmx

An experienced (1 and a half years) in BPO in the capacity of a MIS executive - pertaining to the needs of the backend process of a Telecom company. Professional Profile • Experienced in client relations. • More

$30 USD in 1 day
(0 Reviews)
0.0
azhu

Dear Sir Kindly check your PM for details. Thanks AZHU

$30 USD in 1 day
(0 Reviews)
0.0
zoxno6

If you choose us , you have 25% discount for your next project!

$30 USD in 0 days
(0 Reviews)
0.0
gerryda4268

Good Day! I am a college instructor and I am knowledgeable in MS Office Application especially in MS Excel where I try to record all my students quizzess. And I try linking multiple sheets like what you want to your pr More

$30 USD in 1 day
(0 Reviews)
0.0
melchd

I can do it at the earliset. just tell me when to start

$30 USD in 0 days
(0 Reviews)
0.0
Ishqh

Please check the PM. Looking forward to work for you. Thanks...

$30 USD in 0 days
(0 Reviews)
0.0