Delete selective output from SUMIFS formula?

[phillimm]

I am trying to get the sum quantity of the items both unique and duplicates but with only one output. I've attached my spreadsheet for review, but in case here is what I have.
A B C
ID Key Item Quantity
Mickey wand 6
Minnie shoes 6
Minnie shoes 1
Donald shirt 8
Pluto collar 6
Chip bow 1
Chip bow 4
Chip nuts 1
Dale nuts 2
Daisy bracelet 8
Daisy bracelet 6

In column D (Quantity Adjusted) I have: =SUMIFS(C2:C12,B2:B12,B2,A2:A12,A2). It gives me an output, but what I desire as an output is slightly different and that is where I'm stuck. Here is what I get on the left, and what I desire on the right.

Get Want
6 6
7 7
1
8 8
6 6
5 5
4
1 1
2 2
14 14
6

Any help on this would be much appreciated.

 

[Kerryx]

Pivot Table?

 

[phillimm]

I am trying to get the sum quantity of the items both unique and duplicates but with only one output. I've attached my spreadsheet for review, but in case here is what I have.
A B C
ID Key Item Quantity
Mickey wand 6
Minnie shoes 6
Minnie shoes 1
Donald shirt 8
Pluto collar 6
Chip bow 1
Chip bow 4
Chip nuts 1
Dale nuts 2
Daisy bracelet 8
Daisy bracelet 6

In column D (Quantity Adjusted) I have: =SUMIFS(C2:C12,B2:B12,B2,A2:A12,A2). It gives me an output, but what I desire as an output is slightly different and that is where I'm stuck. Here is what I get on the left, and what I desire on the right.

Get Want
6 6
7 7
1
8 8
6 6
5 5
4
1 1
2 2
14 14
6

Any help on this would be much appreciated.

Solved. Here is my fix formula:

=IF(A2=A1,"",SUMIFS(C:C,A:A,A2,B:B,B2))