Assuming your formula is SUM(B1:B20), try:

=IF(A1="",0,SUM(B1:B20))

Regards,
KL


"hello" wrote in message
...
How do i get a cell with a formula in it to display a zero until a figure
is
typed into a corresponding cell?
All productive help is greatly appreciated.
--
thank you