Need help with formula!

Hi all, I need help with a formula to find a result sorting the data in two columns. there are multiple entries for each group in column A, and each entry has a corresponding weight in column C. I...