Could you perhaps use something like
=IF(COUNTIF(C4:E4,0)>=1,0,SUM(C4:E4))
Alf