I've a speadsheet of product sales data.
The sheet shows sales by product code and the quantity/value per order reecieved.
Is there a way for me to add all of the values per product code to give a total for that piece?
See the attachment for an example of what I want to do. I want to somehow run a formula that will automatically collate the values per product code.
Eg.
Item no. 53040 is repeated 13 time - I'd want to just show this item once with the combined quantity of 69 and value of 222.18
I have a lot of data so need to find a way to do this quickly and easily if possible?
Bookmarks