The solution you choose will depend on how you want the zeroes to
affect other functions.

Option 1 is suitable if you want average function to ignore zero sum.
Option 2 is what you need to include the zeroes in AVERAGE(). Also,
COUNT() will omit blanks but include zeroes.

On Oct 8, 2:56 pm, Sloth wrote:
You can't "hide" a cell the way you can hide a row or column, but you can
make it appear blank.

Option 1: Wrap your formula in an if statement like this...
=IF(SUM(data)=0,"",SUM(data))

Option 2: Make a custom number format that outputs nothing for zero values.
highlight the cells in question
select format-cells-number tab
under "category" click on "custom"
enter the following under "type"
General;-General;;@



"Sundew Chocobo" wrote:
in a nonpivot table, I am trying just to hide the number zero sums. (not the
row or column.)

ideas?

TIA- Hide quoted text -

- Show quoted text -