"Erika" wrote:

I have 5 different worksheets all listing product number and quantity, on the
6th worksheet I was to sum all of the quantities of products with similar
product numbers.

So find all of the product number 1ASB on the previous spreadsheet and sum
there quantities

Erika

If the format is not the same on each sheet, thias is a better way.

List the products in column A. In B2 enter a similar formula to this:
=SUMIF(Sheet1!$A$2:A500,Sheet3!A2,Sheet1!$B$2:B500 )+SUMIF(Sheet2!$A$2:A500,Sheet3!A2,Sheet2!$B$2:B50 0)

You will have to change the ranges to suit and add in the extra sheets (from
3 to six)and copy the formula down.

Regards
Peter