This formula should work there:
=SUMIF(Offense!$C$3:$C$24,$B4,Offense!D$3:D$24)