New
#1
excel formula not shown if the cells are empty
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
Last edited by kf10; 23 Jun 2015 at 02:44.