Hi, I'm no expert at Excel but I was hoping somebody could point me in the right direction.
Im creating a stock inventory (items shipped) spreadsheet where order details are copied in from a csv file. There could be hundreds of orders there with different products and the quantity they have ordered. What Im trying to do is create a formula which would recognise the product name and count the quantity shipped in the column next to it. I would then have a table which could total how many of each product has been shipped on that day.
I've attached a file as a basic example of what I'm aiming to accomplish. Any advice of the sort of formula I'd need would be greatly appreciated.
Bookmarks