F2 and down: =SUMIF($A$2:$A$11, E2, $B$2:$B$11)