Forum Discussion
Summing totals based on part numbers
I have SKUs (part number) in one column that and sales in another column I need to sum the sales and remove the duplicate SKUs once all the sales figures are totaled.
Column P is the Item numbers
Column V is the sales
need to sum the sales based on the part numbers
The easiest way to do that is to create a Pivot Table.
Assuming the Part number is in column A and the Sales in Column B:
- Select any single Cell in your list
- Click on the Insert Tab and select "Pivot tables"
- Accept the Default and Hit Ok >> a new worksheet is created
- To the right side there is a Pivot table Field List
- Drag The Part Number to the Rows Drop area
- Drag the Sales to the Values Drop area
and you are done
You need to apply some formatting specially to the numbers.
Hope that Helps
Nabil Mourad
4 Replies
The easiest way to do that is to create a Pivot Table.
Assuming the Part number is in column A and the Sales in Column B:
- Select any single Cell in your list
- Click on the Insert Tab and select "Pivot tables"
- Accept the Default and Hit Ok >> a new worksheet is created
- To the right side there is a Pivot table Field List
- Drag The Part Number to the Rows Drop area
- Drag the Sales to the Values Drop area
and you are done
You need to apply some formatting specially to the numbers.
Hope that Helps
Nabil Mourad
even if I have thousands of part numbers?
even with hundreds of thousands
