eliminate zero
 

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

--

eliminate zero
 

SS

Try

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"S S" wrote in message
o.uk...
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

--

eliminate zero
 

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

Joerg

"S S" wrote in message
o.uk...
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

--

eliminate zero
 

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))
--
David Biddulph

"Nick Hodge" wrote in message
...
SS

Try

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

"S S" wrote in message
o.uk...
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.

eliminate zero
 

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


S S wrote:

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

--

--

Dave Peterson

eliminate zero
 

Thanks for the help guys.

"Dave Peterson" wrote in message
...
One mo
=if(count(e10:e20)=0,"",sum(e10:e20))


S S wrote:

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

--

--

Dave Peterson