Add the contents of two sheets together

[mwiggins367]

I am looking for a way to add the content of two sheets or even 1 shee
together. I have a large list of part numbers with quantities. Som
of the part numbers are repeated. I would like to add the duplicat
part number quantities together and have just 1 line with the par
number and the total quantity.

Does anyone have any insight?

Thank

 

[Andy B]

Hi

Sounds like a job for a pivot table. See here for an intro:
http://www.cpearson.com/excel/pivots.htm

 

[Frank Kabel]

Hi
have a look at pivot tables for this:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

 

[Roger Whitehead]

An array formula (although slow) will do this:

Assume
Part Nos are in A1:A100
Quantities are in V1:B100

In B101, type
=SUM(IF(A1:A100=A101,B1:B100))
Then Hold Down the Shift & Ctrl Keys and press Enter
The formula should appear as {=SUM(IF(A1:A100=A101,B1:B100))} in the formula
bar
Now, type a Part No in Cell A101
The total Quantity will appear in B101

The important thing is that all elements of the array reference the same
number of rows.