Excel 2007 : Blank not Zero ($0.00) value for =SUM(L11:L144)

[gio24dude]

Hello,

First post here.

I'm working on a spreadsheet and I'm trying to copy the following formula.

=IF(OR(J12="",K12=""),"",J12*K12)

This formula perfect since I always get blank when there is no value in the cell instead of $0.00.

I need to do the same for the following.

=SUM(L11:L144)

I search around and no luck yet, pretty sure this is possible.

I would really appreciate it if someone can help out.

-Gio

[NBVC]

Try:

=IF(SUM(L11:L144)=0,"",SUM(L11:L144))

or you can custom format the cell keeping your original formula.. format cell as Number:Custom with Type: 0;-0;;

[gio24dude]

NBVC,

Perfect, thank you very much for your help here! It works!

Hopefully this will help other people out there as well.

-Gio