Removing Placeholder Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top