Sum If.. Sum Certain Data In One Column Based In A Criteria Of Another Column...

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

Hi

I had a similar problem - I found the solutions on a couple of other web pages - I hope I am allowed to publish them here:

try

http://pubs/logicalexpressions.com/p...cle.asp?ID=103

and

http://cpearson.com/excel/array.htm
and
http://cpearson.com/excel/duplicat.htm

I had to remove blanks from my lists first, but you might not have to, I just them pasted the necessary formats across successive columns - first getting a unique listing of my criteria in one column - you will want CPearsons duplicat page for this

and then using a =SUM((W$2:W$190)*($H$2:$H$190=Z2))

To lookup the unique values in one column 'z' in my example and add the corresponding data point values in column H which were aligned with the instances of the 'unique values' in the column 'H'.

You have to enter all this stuff as array formulae, using CNTRL+ SHIFT+Enter, but I worked out my solution from a standing start and I should think you might be able to as well.

Hope that this is useful.

Julia