I have data of the following structure:

A 100
A 100
A 100
B 5
B 5
B 2
C 55

I need to get

A 100
B 7
C 55

Meaning that the formula would check for all values in second column which have the same value in first column and them sum up only the ones that don't repeat within this range.

For example in data range with A in first column we have 100, 100 and 100. It is repeating therefore formula takes 100 only once. It produces A 100. For B there are values 5, 5 and 2. 5 gets lost, system provides 7 for B. Etc...

Any ideas how I can make it? There are lots of different values for A, B, C in my real data. Could be 50 different values, could be a hundred.