eliminate zero

S

S S

Formula =SUM(E10:E20)
If there are no amounts in this column then the total displays 0
Is there a way to display the total cell as blank so that the 0 does not
appear.

thanks

--
 
J

Joerg

Format => Format cells => Number => Custom
Now input a new custom format: #;#;;

Joerg
 
D

David Biddulph

Note that Nick's suggestion, and the one from Joerg, would give a blank
answer if there are numbers in at least some of the cells but they add up to
zero. If you want to give a zero answer in that case, but a blank if all
the input cells are blank, try
=IF(SUM(NOT(ISBLANK(E10:E20)))=0,"",SUM(E10:E20))
 
D

Dave Peterson

One more:
=if(count(e10:e20)=0,"",sum(e10:e20))


S said:
Formula =SUM(E10:E20)
If there are no amounts in this column then the total displays 0
Is there a way to display the total cell as blank so that the 0 does not
appear.

thanks

--
Click to expand...
 
Top