Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 -- |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 -- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 -- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I eliminate grid lines in an EXCEL Surface chart? | Charts and Charting in Excel | |||
eliminate partial text in many fields | Excel Worksheet Functions | |||
How to eliminate empty rows in Excel 2002 worksheet ? | Excel Discussion (Misc queries) | |||
How to eliminate xero values from pivot table and list top 10 only | Excel Worksheet Functions | |||
How to show zeros (0) as "slashed" to eliminate confusion with "O. | Excel Discussion (Misc queries) |