How to get a sum of "0" to be blank in the cell

[dixiebritt]

I am running a report where I want the cell to remain blank, if the result is "0".

for example, I have a list of clients in column A. List of months in A-M. Their billings are in the cells. When calculating their YTD, if their total was zero, I want the cell to remain empty, with no number figure. I tried a couple of IF formulas, but i keep getting an error.

 

[S.H.A.D.O.]

Do you mean something like this?

=IF(SUM(B1:M1)=0,"",SUM(B1:M1))

Change the cell references to suit.

I hope this helps!

 

[Misca]

The easiest way to show zeroes as empty cells is by number formatting. If you're not familiar with number formatting start with one of the existing ones. Then change the cell formatting to "Custom" and you'll see the the original formatting. Then leave the first two formats (= positive and negative numbers) as they are and after the second ";" just add another ";" and remove whatever there might have been.

Custom cell formatting # ##0,00\ _€;[Red]-# ##0,00\ _€;; displays positive numbers as 1 234,56 €, negative numbers are formatted the same but in red and starting with a minus sign and zero values as blank cells.

 

[dixiebritt]

This was it. I had it in the wrong order. Thank you.

 

[S.H.A.D.O.]

You're welcome, I'm glad I could help!