=SUMIFS(H4:AL4,$H$2:$AL$2,"<>1",$H$2:$AL$2,"<>7")-B4*8