Solved excel formula not shown if the cells are empty

[kf10]

i have excel file, with the following formulas

Cell G2 formula =SUM(D2:F2)
Cell G3 formula =SUM(G2, D3:F3)
Cell G4 formula =SUM(G3, D4:F4)
Cell G5 formula =SUM(G4, D5:F5)

i want the result of G5 (and the rest of G cells) cells to be invisible unless there is some value in D5 to F5 cells

please forgive my poor english

 

[GokAy]

I haven't used for a very long time but I guess you can accomplish this with a conditional cell formatting.
Also belongs to the Office section.

 

[Boozad]

You'll need to enter the formula shown below (note the blank cell selected contains the formula yet remains blank). Amend the formula for each line using the relevant cell numbers.

​

 

[kf10]

thanks a lot Boozad

you solved my problem

 

[Boozad]

You're welcome.