Blank Cells with Formula

[Jane]

In the Excel spreadsheet attached, a same formula (e8=d7+e7, e9=d8+e8, e10=d9+e9, ----) is used from cells e8 to e17. How to make the cells from e10 to e17 to keep blank until cells d10 to d17 have values filled.
Thank you very much!

[Brandtrock]

Try this in cell E8:


=IF(ISBLANK(D7),"",D7+E7)

Copy down the rest of your range and it should work for you.

Regards,

[Roaddog]

Hi Jane,


Try this.

In cell E8


=SUM(D7+E7)*COUNTIF(D7,">0")

and drag down to cell e11.

hope it helps