SUM IF? Summing a certain column based on another column data being the same per cell

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

Dee

Why not take a look at Data>Pivot Table Report...?

Would like to have the run under a macro.

also, I am not sure how I would accomplish what I need with a pivot table. your help would be greatly appreciated.

Thanks,
Dee