I am interested in learning how to accomplish the following:

A B C
12 1
12 2 3
1 5 5
2 9 9
32 10
32 12
32 11 33
432 54
342 44 44
432 4 58

Column A = the item number.
Column B = total qty per location
Column C = total qty for item

What I am trying to do is get a total sum per item. So, if their is 453 listed 8 times, it should sum up the total qty per the eight locations.

I am trying the sum if and was able to get it for two like item #.

I look forward to your help!

Dee