sum list items and consolidate duplicates

[b19upj]

Hi,
I have a list of codes (column A), and amounts of money (Column B).
I would like to sum all of the codes but where the codes are the same, only have the sum for the first instance of that code from the list.
eg see the example below
TIA

CODE	AMOUNT	RESULT
CAT	5	11
DOG	6	16
RABBIT	4	4
FISH	5	5
PIG	7	7
DOG	6	0
HAMPSTER	8	8
GUINEA PIG	3	3
DOG	4	0
CAT	6	0
HEDGEHOG	5	5

 

[Fluff]

How about

=IF(COUNTIF(A$2:A2,A2)=1,SUMIFS(B:B,A:A,A2),"")

 

[b19upj]

How about

=IF(COUNTIF(A$2:A2,A2)=1,SUMIFS(B:B,A:A,A2),"")

Thanks for this. I used this as an idea but changed it a little as I used a different column to do a unique count.
So my formuale was =if(countif($D9:$D9,D9)=1,1,0)

 

[Fluff]

You're welcome & thanks for the feedback.