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

Mail Merge Switch - Dollars to Words	0	Nov 18, 2022
Sort column beginning with blank?	1	Oct 30, 2012
Newbie Help - IF Yes No Function	0	Jan 26, 2022
Use TODAY() function as the criteria in a SUMIF formula	1	Jul 17, 2018
Word macro that can call cells out of Excel for a find and replace	0	Dec 7, 2022
Formatting question: how to format duration (time spent)?	0	Feb 6, 2021
COUNT BLANK AND ZERO AS THE SAME THING	6	Apr 9, 2010
If Function neglecting 0 as a number	1	Nov 9, 2013

Ask a Question