You're welcome, Sarah!
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"sarahmross" wrote
in message ...

Anne,

Thank you so much!! The second formula worked for me,
the =IF(SUM(C1:C5)=0,"",SUM(C1:C5)). It did what was needed, entered
nothing in the cell, and still kept the sum formula....

Hats off to you, thank you once again!

Sarah


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