HOW DO MAKE ZEROES DISAPPEAR WHEN THERE ARE NO NUMBERS TO SUM
 

I have formatted multiple cells to SUM when the appropriate data is input.
But until that data is input, it puts a 0(zero) in the cell. Is there any
way to make the cells blank until actual data is input without clearing the
cell of the SUM command?

HOW DO MAKE ZEROES DISAPPEAR WHEN THERE ARE NO NUMBERS TO SUM
 

Tazman,

I don't know if this is exactly what you're looking for, but try setting
conditional formatting on the cells.

Mark

"tazman2168" wrote:

I have formatted multiple cells to SUM when the appropriate data is input.
But until that data is input, it puts a 0(zero) in the cell. Is there any
way to make the cells blank until actual data is input without clearing the
cell of the SUM command?

HOW DO MAKE ZEROES DISAPPEAR WHEN THERE ARE NO NUMBERS TO SUM
 

something like
=if(sum(a23:a45)=0,"",sum(a23:a45))
--
Greetings from New Zealand
Bill K
"tazman2168" wrote in message
...
I have formatted multiple cells to SUM when the appropriate data is input.
But until that data is input, it puts a 0(zero) in the cell. Is there any
way to make the cells blank until actual data is input without clearing
the
cell of the SUM command?

HOW DO MAKE ZEROES DISAPPEAR WHEN THERE ARE NO NUMBERS TO SUM
 

Either test for zero value then place a null in the cell if true or the sum
if false

=IF(SUM(A1:A10)=0,"",SUM(A1:A10))

or remove all zeros from the sheet by clicking ToolsOptionsView and
uncheck Zero Values

"tazman2168" wrote:

I have formatted multiple cells to SUM when the appropriate data is input.
But until that data is input, it puts a 0(zero) in the cell. Is there any
way to make the cells blank until actual data is input without clearing the
cell of the SUM command?

HOW DO MAKE ZEROES DISAPPEAR WHEN THERE ARE NO NUMBERS TO SUM
 

tools/options uncheck the zero values option

--


Gary


"tazman2168" wrote in message
...
I have formatted multiple cells to SUM when the appropriate data is input.
But until that data is input, it puts a 0(zero) in the cell. Is there any
way to make the cells blank until actual data is input without clearing
the
cell of the SUM command?

HOW DO MAKE ZEROES DISAPPEAR WHEN THERE ARE NO NUMBERS TO SUM
 

Is there a difference between no cells to sum and cells with zero,
and cells that sum to zero.

from previous example:
=if(sum(a23:a45)=0,"",sum(a23:a45))

=IF(Count(A23:a45)0,Sum(A23:a45),"")
would show the zero if the actual sum is zero, but an empty string
if there were no numeric values in the range.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"tazman2168" wrote in message ...
I have formatted multiple cells to SUM when the appropriate data is input.
But until that data is input, it puts a 0(zero) in the cell. Is there any
way to make the cells blank until actual data is input without clearing the
cell of the SUM command?