Hi Hello

You will need an IF statement in front of the SUM statement which will
force the answer to be dependent on the input (G7)

The syntax is IF(argument,true,false)

IF(g7="",0,sum(g7-1830))

So if G7 is empty, the formula will return nil (0), otherwise it will
return the answer of the sum (g7-1830)

Jon


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=466127