Sum up excel columns by Part #

$10-30 USD

Terminado

Publicado

hace alrededor de 5 años

$10-30 USD

Pagado a la entrega

I have two separate excel sheets that I need data summed up. There is a quantity column and a Vendor Part number column. These represent each individual sale of a Vendor Part #. I need the quantity column totaled by Part #. For example the spreadsheet Special Order Sales has the following items: 1 BMP3422068C 1 BMP3422068C 2 BMP3422068C 1 BMP3422068C 1 BMP3422068C 1 BMP3422068C 1 BMP3422068C 1 BMP3422068CSO I want this to show up in a seperate tab as 7 BMP3422068C 1 BMP3422068CSO If it could be done where I could collapse all of the items of each part number and just have a total row for each individual part #, that would be great. I hope this makes sense. I believe it is a very simple project. I Just do not know the best way to do it and am wasting a lot of time trying to figure it out. I will award this project based on price, of course, but also who can get it done immediately.

Data Entry

Data Processing

Excel

ID del proyecto: 18550426

Información sobre el proyecto

11 propuestas

Proyecto remoto

Activo hace 5 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@SBITServices

Hello Vinval, It is very simple task and i can sum up these with excel formulas. I have 5 years experience in advanced concepts like Pivot table, Vlookup, Charts, Data analyser etc. I never ask for payments in front. You can release the agreed milestones once the task is completed and you're happy with [login to view URL] my reviews to confirm my work quality With Regards, Sai

$15 USD en 1 día

4,9

(441 comentarios)

7,5

@bhupendrayadav

I have more than 5 years of experience in advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I can deliver this project in less than 1 hour You can get your work done here with highest quality at lowest price. I accept only once you are fully satisfied with the work done. Looking forward to work with you

$15 USD en 1 día

4,6

(15 comentarios)

4,0

11 freelancers están ofertando un promedio de $24 USD por este trabajo

@cgullapalli

HI, I am good at Excel and pivot tables. I see your requirement. I can summarize the data using pivot table quickly as required. Looking forward to work on this and provide quick turn around. -Chandra

$10 USD en 0 día

5,0

(802 comentarios)

7,9

@sergiuloghin

Hello! Ican resolve this using a VBA script. I can finish in 1-2 hours max. Thank you! I am ready to start now.

$30 USD en 0 día

5,0

(217 comentarios)

7,5

@saqibmunir55

sure i can do it right now sure i can do it right now sure i can do it right now sure i can do it right now

$20 USD en 1 día

4,9

(566 comentarios)

7,3

@TonmoyRoy111

Hello client I can do the task fast. I understand what is required to be done. Please contact mme. Roy

$25 USD en 0 día

4,9

(288 comentarios)

6,6

@lightingdavid

Hello? How are you? I have good experiences in "Sum up excel columns by Part #" as you can see my profile for these (Data Entry, Data Processing, Excel). I have been working for 7 yrs in this scope. While we contract and work in our jobs, I will get paid once you have confirmed satisfied result. If I do not deliver satisfied result, I will never get paid from you. We can discuss more details to understand more easily if you have other infos. Hope to work with you. Thank you.

$55 USD en 3 días

4,5

(14 comentarios)

4,9

@icatherinedivya

Hi I have written a lot of Python script to process any CSV/Excel fields. I can do this quickly. Please send me a message. You can check my reviews for more info. :) Thanks

$20 USD en 1 día