Excel Add Qty for Unique Parts?

[mfleming]

Hello.

I'm combine unique names and add the quantities. I use data extraction in AutoCAD to excel and I get all my Parts and qtys.

Column-A = Parts Name
Column-B = Qty for Parts in Column A
Column-C = Parts Name
Column-D = Qty for Parts in Column C
Column-E = Parts Name
Column-F = Qty for Parts in Column E
.... ect up to Column V

See Image:

http://www.homenkobuilders.com/images/parts.png

Basically I want each unique part and its quantity.

I tried using a lookup but I haven't really used it very much and can't get it to work properly.

Any Suggestions?

Thanks

 

[BigInch]

Lookup array data needs to be sorted by num or alpha. Try sorting that and see if lookup works.

http://virtualpipeline.spaces.msn.com

 

[joerd]

You'll probably want to look into a Pivot Table. Dependent on what you want to do, you may have to rearrange your list into two columns (Part and Quantity) before you set up the pivot table.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[psafety]

The function SUMIF will get you going.

 

[mfleming]

Thanks I'll look into Pivot Tables.

I tried the sumif function but I couldn't get a good way to cycle through all the data when its not in just two columns.