Sum Distinct value for same markets

Hi Team,

I have data like below Tbl 1 and values are repeated but i need to sum distinct value only see Tbl 2.

Tbl 1 :

Tbl 2 :

Thanks,

KV's