Hello all,
I am struggling to find the right formula.
In column A I have a bunch of article numbers. Some of these article numbers are in this column more then once (on different orders).
In column B I have the amount of the articles I ordered of each order.
What I am looking for is a formula to calculate the total amount of each item I ordered.
So when I ordered an item once, it's no problem.
But when I ordered an item on 2 orders, lets say the first time 2 pieces and the second time 3 pieces, I want to see I have ordered a total amount of 5 pieces for this item.
And when I ordered an item on 3 orders, lets say the first time 3 pieces, the second time 1 piece and the third time 2 pieces, I want to see I have ordered a total amount of 6 pieces for this item.
Etcetera...
Hopefully I explained it well.
Bookmarks