eliminate zero

[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

--

 

[Nick Hodge]

SS

Try

=IF(SUM(E10:E20)=0,"",SUM(E10:E20))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[Joerg]

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

Joerg

 

[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))

 

[Dave Peterson]

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

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

--

 

[S S]

Thanks for the help guys.

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