I have a spreadsheet in which I enter numbers in, then calculate a
certain range -
sum(f4:f10). The cell that contains this formula always shows 0 if
nothing is entered in this range. How can I edit this forumla that will
display nothing in the cell if nothing is entered, if something is
entered, then it will display the sum
Any suggestions?
--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile:
http://www.excelforum.com/member.php...o&userid=24735
View this thread:
http://www.excelforum.com/showthread...hreadid=397250