Hi, I have two worksheet formulas:

* =E7+F7 (In Cell G7)
* =SUMPRODUCT((YEAR(Purchases!$J$7:$J$30)=A$7)*(Purchases!$G$7:$G$30)) (In Cell C7)

In the first formula, I would like G7 to be blank instead of a zero providing both E7 and F7 cells are 0 too. The reason I need E7 and F7 to both be 0 is in the case
G7 equals zero and needs to be displayed because it is the actual result of E7 and F7 having values.

I need the same in C7 for the second formula. However, if G7 again equals 0 as the result of a formula from E7 and F7, I need 0 to be displayed.

Thanks.