Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
if no data in cell show as blank
Hi George,
try this formula instead: =IF(SUM(F803:F808)=0,0,SUM(F803:F808)+H799) it returns a 0 if the sum range is balank, if you want a balnk cell, replace the 0 inbetween the two comas with "" Regards, Suresh "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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
if no data in cell show as blank
Try this:
=IF(SUM(F803:F808,H799),SUM(F803:F808,H799),"") -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "George" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
if no data in cell show as blank
Thank you very much, that worked great
-- George "Suresh Sadanandan" wrote: Hi George, try this formula instead: =IF(SUM(F803:F808)=0,0,SUM(F803:F808)+H799) it returns a 0 if the sum range is balank, if you want a balnk cell, replace the 0 inbetween the two comas with "" Regards, Suresh "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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
if no data in cell show as blank
If the entries can be 0 or positive and negative, maybe:
=if(count(f803:f808,h799)=0,"",sum(f803:f808,h799) ) If text entries are ok, you could use =counta() =if(counta(f803:f808,h799)=0,"",sum(f803:f808,h799 )) 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a cell show relevant data | Excel Discussion (Misc queries) | |||
Copy data in one cell to blank cell immediately below, repeat | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Want #VALUE! to show as blank cell | Excel Worksheet Functions | |||
How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) |