Look up and adding the correspondent quanties

**Attila Toth** · 01-21-2010, 02:02 PM

Hi,

I have a database in Excel 2003 with two columns, almost 11,000 rows
one column with item codes, many in multiple cells, second column indicates quantity,
Can somebody help me with what functions can I add the quantities for the items showing in multiple cells, and have only one row showing the result,
Example:

AC-BN-BAN01 16500
AC-BN-BAN01 9000
AC-BN-BAN01 12500
AC-BN-BAN02 3
AC-BN-BAN05 9
AC-BN-BAN05 600
AC-BN-BAN05 600

I need to have only this info:
AC-BN-BAN01 38000
AC-BN-BAN02 3
AC-BN-BAN05 1209
etc

Thank you
A

**NBVC** · 01-21-2010, 02:04 PM

Try Pivot Tables:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

**Attila Toth** · 01-21-2010, 02:16 PM

Thanks, I'm not really familiar with Pivot Table - do you have a quick idea which one would be helpful in this case?

**NBVC** · 01-21-2010, 02:22 PM

There is only one Pivot Table.. it just depends on your setup..

Select the range of data, including the titles go to Data|Pivot Tables and Pivot Charts....

Click Next in the 1st Step..

Ensure the range is correct in the 2nd step.

Click Next

Choose where you want the result to go and click Layout

Drag the button with the Item Code column title and drag it to the Row area

Drag the quantity button to the Data Area.... it should say Sum of Quantity or similar... If it says Count, then double click that and choose sum.

Click Finish