=SUM($B6:$D6)*COUNTIF($E6:$G6,I$4)/COUNTA($E6:$G6)

Shorter but the same result. COUNTIF what I wanted to use before but wasn't finding it in the function list.