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




Try this it should work, this will leave the cell blank if there are no
values to add.

Did I understand this right ?


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