From: gp on 17 Mar 2010 12:49 I have multiple instances on my spreadsheet of the same part number that I am tracking. In the differernt lines I have the different quantities of the same part number. I want to ultimately pull them together to get a TOTAL, how do I do this? From: Pete_UK on 17 Mar 2010 13:40 You might want to do it on a separate sheet, where you can list the different part numbers once in column A. Then in B1 you can have this formula: =SUMIF(Sheet1!part_num,A1,Sheet1!quant) where part_num is the column that you have your part numbers in on Sheet1, eg E:E, and quant is the column where the individual quantities are found on Sheet1, eg M:M. You can use full-column references with SUMIF. Then just copy the formula down to get summary totals for each part number. Hope this helps. Pete On Mar 17, 4:49 pm, gp wrote:> I have multiple instances on my spreadsheet of the same part number that I am > tracking. In the differernt lines I have the different quantities of the same > part number. I want to ultimately pull them together to get a TOTAL, how do I > do this? From: Ashish Mathur on 17 Mar 2010 19:25 Hi, You may create a pivot table. Drag part number to the row area and quantities to the data area -- Regards, Ashish Mathur Microsoft Excel MVP "gp" wrote in message news:8BD3D011-4C91-47D8-81A1-E68ED036B207(a)microsoft.com...> I have multiple instances on my spreadsheet of the same part number that I > am > tracking. In the differernt lines I have the different quantities of the > same > part number. I want to ultimately pull them together to get a TOTAL, how > do I > do this?  |