Functions Return 0

Jonathan Grotegut · Oct 10, 2003

All functions are ruturning zero when there is no data.
Is there a way to show them as blank instead of having the
0? TIA

Peo Sjoblom · Oct 10, 2003

One way

=IF(COUNTBLANK(A1:A50)=50,"",SUM(A1:A50))

JON JON · Oct 11, 2003

Tools|Options|View, unchecked zero values.
All zeroes will be shown as blanks