In I7 perhaps
=SUMIF($B$7:$B$18257,$H7,$E$7:$E$18257)
then double click the handle at the lower right corner of the cell A pivot table will also be possible