SUMIF based on unique values in another column

[Anglais428v2]

Criteria	Value
A	10
A	10
B	20
C	40

I would like a formula that sums the Value column based only on unique strings in the Criteria column.
For example, in the above sample, the output should be 70 (10+20+40). I.e. it should count the first A value but ignore the second A value.
I can't remove duplicates from the sheet, therefore looking for a formula-based answer.

Thanks

 

[Fluff]

Will the value always be the same for each criteria as shown for A?

 

[Anglais428v2]

Yes, so if there is a duplicate for A (in the example) the value would always be 10.

 

[Fluff]

Ok, how about

=SUM(UNIQUE(A2:B5))

 

[Anglais428v2]

it was that simple!
Many thanks!

 

[Fluff]

You're welcome & thanks for the feedback.