If your data table starts in A1 and the data begins in row 2:

Try putting this formula in Cell E1:
=SUM(1/COUNTIF($A$2:$A$10,$A$2:$A$10)*$D$2:$D$10)

(Note: Commit that array formula by pressing [Ctrl]+[Shifr]+[Enter]

Regards,
Ron