worksheet function - Filtering a column and summing values (in Excel)

I have an Excel worksheet, pieces of which are shown below:

I want to filter column D so they're unique (i.e., cat, dog, fish) and sum the values corresponding to those values like this:

I'm familiar with filtering ranges in Excel, formulas, and such functions as COUNTIF(), but I can't make this work.