if sum is 0, return a blank

[Staci]

How can I make the following code say...if returning a 0, then " "
I dont want a screen full of 0's, would rather have empty cells?

Please Login or Register  to view this content.

[MarvinP]

Please Login or Register  to view this content.

[Cutter]

Or you could just tell Excel (in the options) to not show zeros for that sheet.

Or you could use Conditional Format to apply a white font if cell = 0.

[Staci]

Please Login or Register  to view this content.

i tried this formula, but I forgot the "=0" part...go figure,

Thanks Marvin

Other good ideas, will remember those, thanks Cutter!