if no data in cell show as blank

G

George

Iv got the following formula in cell H803:
=SUM(F803:F808)+H799
Is there a way that if there is no data in any of these cells (F803:F808).
Cell H803 remains blank.
 
G

George

Didn`t work. The cell remains blank when data is inserted in any of the cells
F803:F808.
 
E

Evan

sorry - pls try

=IF(SUMPRODUCT(--(F803:F808<>"")),"x","")

Aside from change of range, the test was backwards
 
Top