MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sum w/Blank

Posted by Dee on January 15, 2002 9:05 AM

I can't seem to get my sum to return a blank cell no matter what I try. Please help me. I want the total to show only if it's above 0.

Posted by Juan Pablo G. on January 15, 2002 9:13 AM

Format the cell as


Juan Pablo G.

Posted by Aladin Akyurek on January 15, 2002 9:32 AM

How about custom formatting the cell of this formula as


and when you read off this cell, you must be aware of the fact it really has 0 in it if its value is not > 0.