I have ~500 rows of data in columns A, B, C that is as follows, for example:
Qty Shipped......Invoice Number.......Product
14...................ZETWS..................Apples
16...................ZETWS..................Apples
19...................ZETWS..................Apples
13...................ZETWS..................Apples
36...................TWETY..................Bananas
33...................TWETY..................Bananas
38...................TWETY..................Bananas
32...................TWETY..................Bananas
21...................UWRYE..................Pears
26...................UWRYE..................Pears
23...................UWRYE..................Pears
28...................UWRYE..................Pears
I am having trouble with coming up with a formula that will add up the total items shipped for each item. For example, Apples = 62 items shipped. Any assitance is appreciated.
Bookmarks