Hi everyone,
I promise I have searched the boards, but I just can't figure out how to solve my problem![Eek! :eeek: :eeek:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)
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
![Eek! :eeek: :eeek:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)
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:
![2ufc7jk.png](/board/proxy.php?image=http%3A%2F%2Fi68.tinypic.com%2F2ufc7jk.png&hash=ed261810b27d32491738fcbe39a0890b)