help with formula sum?

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
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with formula 1
Help with formula 1
Need help with a formula, please!!! 2
Add/Subtract columns from tab to tab in same file 3
IFSUM and IFSUMS - which to use and how 4
Multiple lookup criteria 3
Formula Question 2
Match 2

Top