this could work
=IF(D238,D23-8)+IF(D248,D24-8)+IF(D258,D26-8)+IF(D268,D26-8)+IF(D278,D27-8)+IF(D3040,D28)+IF(D3040,D29)
--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread:
http://www.excelforum.com/showthread...hreadid=560102