Sum If.. Sum Data Depending On The Nature Of Another Column...

[deedee]

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

[deedee]

Opps I made a typo in the numbers, the following is correct:

Let me try clarifying too...

A--------------B------C
DOG55-----------2------
DOG55-----------3------
CAT22------------3------
MOUSE66---------7------7
DOG55-----------4------9
CAT22------------4------7
RABBIT44---------3------
RABBIT44---------2------
MONKEY66-------1------1
RABBIT44---------3------8

Column A = Item #
Column B = Qty of Item per location
Column C = Total Qty of Item in all locations

I look forward to your help!

Thanks,
Dee

[Domenic]

Try...

C1, copied down:

=IF(COUNTIF($A$1:A1,A1)=COUNTIF($A$1:$A$10,A1),SUMIF($A$1:A1,A1,$B$1:B1),"")

Hope this helps!