SumIf - want first answer, not duplicates

[Mandy_]

Hi,
I'm creating a document, where I want the number of items added, where the criteria is met, but for the duplicates to be ignored.
I've attached a screen shot, showing the formula I'm using and what I would like to have the answer be.

Thank you for your help.

 

[Fluff]

How about

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

 

[Mandy_]

Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.