If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Microsoft Excel Total Values
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? |
#2
|
|||
|
|||
Microsoft Excel Total Values
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? |
#3
|
|||
|
|||
Microsoft Excel Total Values
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 ... 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? |
Thread Tools | |
Display Modes | |
|
|