help with formula sum?

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

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