Maybe ...

=if(counta(a1:a10)<10,"",sum(a1:a10))

It waits until there's something in all 10 cells before doing the sum. Make
sure that number matches the number of cells in the range (I used 10 and
A1:A10).



junkmandan wrote:

How can I insert a formula, say the sum of a column, without the cell
showing a zero sum, until the formula has been applied. My form looks
messy with all the zero values without any other information in the
form.

Thanks

--
junkmandan
------------------------------------------------------------------------
junkmandan's Profile: http://www.excelforum.com/member.php...o&userid=30866
View this thread: http://www.excelforum.com/showthread...hreadid=505450

--

Dave Peterson