Good Morning Folks
Each morning I pull a download from my website of what has been sold.
This in on a line item basis, where column A gives the product code, column B gives the qty sold. Then the next line moves onto the next code (if there are no more products on that order, it moves onto the next order)
(Please see attached sheet - its probably easier?!)
What I need to do is Excel add up how many of each product code has been sold, so I can double check I have the stock to fulfil the order, if not I can have it delivered that day.
I used to do this using a COUNTIF function to count the product codes (and then filtering the duplicate rows of product codes) however this is only counting how many times the code appears, and doesn't account for when someone orders 3 of that item on a given row.
Can anyone help me with this please? I've tied myself up in knots so far!
Kindest Regards
Mark
Bookmarks