Sep 09 2019 11:06 AM - edited Sep 09 2019 11:23 AM
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
Sep 09 2019 11:22 AM - edited Sep 09 2019 11:25 AM
SolutionThe 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:
and you are done
You need to apply some formatting specially to the numbers.
Hope that Helps
Nabil Mourad
Sep 09 2019 11:24 AM
even if I have thousands of part numbers?
Sep 09 2019 11:26 AM
even with hundreds of thousands
Sep 09 2019 11:27 AM
Sep 09 2019 11:22 AM - edited Sep 09 2019 11:25 AM
SolutionThe 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:
and you are done
You need to apply some formatting specially to the numbers.
Hope that Helps
Nabil Mourad