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?
|