In Sheet1,
Assume part numbers are listed in A2 down
Put in B2: =SUMIF(Sheet2!A:A,A2,Sheet2!B:B)
Copy down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Richard" wrote:
I have a quantity in Column B and the part number in Column A on sheet2.
Which is listed multiple times. How would you send the total quantity to
sheet 1 where ever that part number is located. Example:
Sheet2
RT-005 Qty 2
RT-005 Qty 3
RT-005 Qty 9
On sheet1 where ever RT-005 is the Qty. should be 14