Adding cells : If one cell is zero, how do I return zero for the whole formula?

[MHTMHT]

Hi everyone,

I promise I have searched the boards, but I just can't figure out how to solve my problem

It looks like I could use SUMIF, but I just can't get my head around how to do it.

Basically I want to sum cells, not the same range, different ones within a column.

The difficulty is that because if the subject I am working on if one of the cells to be added contains a zero, then the result SUM must equal zero, i.e. if there is a zero it nullifies the values of the other.

In the screenshot attached, I want the highlighted cell to return zero because I7=0

Any help would be appreciated!

Screenshot of my sheet:

 

[Scott Huish]

=if(or(i4=0,i5=0,i7=0),0,i4+i5+i7)

or

=(I4+I5+I7)*((I4*I5*I7)<>0)

 

[MHTMHT]

=if(or(i4=0,i5=0,i7=0),0,i4+i5+i7)

or

=(I4+I5+I7)*((I4*I5*I7)<>0)

Thank you very much!