Removing Placeholder Values

[Guest]

I dont want to show place holder values that show were there are formulas but
the cells referenced by the formulas dont have values as yet. e.g cell G34
has formula: =SUM(F24:F33) and the referenced range has no values but G34
shows 0.00. The number format of G34 is NUMBER with a 1000 SEPARATOR to 2
DECIMAL PLACES.

 

[Guest]

Try

=IF(SUM(F24:F33)>0,SUM(F24:F33),"")

Mike

 

[Dave Peterson]

I'd use count.

=if(count(f24:f33)=0,"",sum(f24:f33))
or
=if(count(f24:f33)<10,"",sum(f24:f33))

Any cell filled with a number shows the sum--or all the cells filled in with
numbers shows the sum.