=IF(SUM(A40:A43)+(SUM(A30:A33))=0,"0",SUM(A40:A43) +SUM(A30:A33))



This will return "0" in the cell if the cells your adding have no
values if thats what you want.


--
bbuzz
------------------------------------------------------------------------
bbuzz's Profile: http://www.excelforum.com/member.php...o&userid=28466
View this thread: http://www.excelforum.com/showthread...hreadid=480956