In F2 - =SUMIF($A$2:$A$10,E2,$B$2:$B$10) and copy down