if no data in cell show as blank
 

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

if no data in cell show as blank
 

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

if no data in cell show as blank
 

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

--
George


"Evan" wrote:

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

if no data in cell show as blank
 

sorry - pls try

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

Aside from change of range, the test was backwards

"George" wrote:

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

--
George


"Evan" wrote:

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

if no data in cell show as blank
 

Thanks very much, another obtion I can use. Very useful.
--
George


"Evan" wrote:

sorry - pls try

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

Aside from change of range, the test was backwards

"George" wrote:

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

--
George


"Evan" wrote:

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