Removing Placeholder Values
 

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.
--
Wether you think you can or you think you cant , you are right ... anon

Removing Placeholder Values
 

Try

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

Mike

"Mtabaruka" wrote:

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.
--
Wether you think you can or you think you cant , you are right ... anon

Removing Placeholder Values
 

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.



Mtabaruka wrote:

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.
--
Wether you think you can or you think you cant , you are right ... anon

--

Dave Peterson