Without seeing your formula, an applicable solution is just a guess.
The following formula will sum A1:A10 if there are any numeric values
in the range. If the range is empty or has only text data, it returns
an empty string.

=IF(COUNT(A1:A10)0,SUM(A1:A10),"")

You can do something very similar with individual cells rather than
ranges. The following formula looks at A1, A3, and A5 and sums them if
there is a numeric entry. Otherwise, it returns an empty string.

=IF(COUNT(A1,A3,A5)0,SUM(A1,A3,A5),"")

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Fri, 20 Mar 2009 08:43:44 -0700 (PDT), Ty
wrote:

I have cells that display the sums from other worksheets. As it stand
right now if there is no value in the other worksheet the a 0
appearers in the totals cell. What I would like to do if possible is
instead of there being a 0 in the totals cell I would like it just to
be blank.

I have set up conditional formatting on the total cells to change the
font color if the value is greater than 0 but cannot seem to get rid
of the zero if there is no value to display.

Thanks,

Ty