What formula can I use to end up with a blank cell,if the sum of all cells equals 0 TNA Phil
P Phil Mar 11, 2007 #1 What formula can I use to end up with a blank cell,if the sum of all cells equals 0 TNA Phil
D Dave Peterson Mar 11, 2007 #3 You can't really get an empty cell--but you can make it appear empty. =if(sum(a1:a10)=0,"",sum(a1:a10)) If you're really trying to avoid a number if the data hasn't been entered: =if(count(a1:a10)=0,"",sum(a1:a10)) Then you could still see a 0 if you have numbers that sum to 0.
You can't really get an empty cell--but you can make it appear empty. =if(sum(a1:a10)=0,"",sum(a1:a10)) If you're really trying to avoid a number if the data hasn't been entered: =if(count(a1:a10)=0,"",sum(a1:a10)) Then you could still see a 0 if you have numbers that sum to 0.
