Seeking excel formulas to make my life easier

I am seeking help in working out a couple of excel formulas. I have included a snip of the data that I am working with and the outcome that I am seeking to streamline with the use of formulas.

Ignoring column A. I want to copy the values from B & C but there are duplicate values in column B which I want to ignore, unless the value in column C is different for the value in column B. So I want to get the values across from B & C as per columns F & G). Then I want to sum the values from D, to be as per column H.

Hopefully you can decipher what I am after and provide some suggestions for how to tackle this.

General info: Windows 10, Excel 2016

Recent Questions...