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:
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:
