You can use the CSE formula

sum(if ($c$10:$c$50000=$C2,$D$10:$D$50000))

You must press CTRL+Shift+Enter together to enter this in the cell

put it in D2 and then copy it to D3,D4 and D5. You have to copy it one cell
at a time.