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.
=SUM(C4:C15)


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

Format the cell as

0.00;-0.00;

Juan Pablo G.

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

How about custom formatting the cell of this formula as

[=0]"";General

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.

Aladin

=====