Hi there,

Try nesting your Sum formula within an If Formula

=If(Sum(A1:A10)=0,"",Sum(A1:A10))

--
Ken Puls
www.officearticles.com


"sarahmross" wrote
in message ...

Is there such a formula that will leave a cell empty? Example: I use
the formula SUM(...) to add up orders...but, if there are no orders in
that category, then the cell will have the value of "0.0". Is there
any way to leave the cell blank (with the formula still in there) when
there are no orders? I really need help on this, it's driving me
mad!!! Any help would be sweet.

Thanks! -Sarah



--
sarahmross
------------------------------------------------------------------------
sarahmross's Profile:
http://www.excelforum.com/member.php...o&userid=28725
View this thread: http://www.excelforum.com/showthread...hreadid=484179