Hi Ben,

A two-step process :
1. For Column A to produce Unique Values in Column C :
Data Filter Advanced Filter with Unique Values
2. In Column D :
=SUMIF(ColumnA,ColumnC,ColumB)

HTH
Cheers
Carim