You can just "filter" the column of interest, then use the SUMIF formula to sum....

I showed a formula solution also above to get the unique list.