You could just have =SUM(E2:E76) in cell J1 and rework your SUMIF to a simpler IF .
=SUM(E2:E76)
SUMIF
IF