F3: =SUMIF($A$3:$A$24,$E3,$B$3:$B$24)

and copy down.


Regards