|
help with formula sum?
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 |
help with formula sum?
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 |
| All times are GMT +1. The time now is 09:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com