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