Add the contents of two sheets together

M

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
 
R

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.
 
Top