if a1:c1 is the range of interest, try in d1:
=IF(SUMPRODUCT(--(A1:C1="")),"","x")

"George" wrote:

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.
--
George