You could use the following =SUM(D7:D8,D10:D11) this would exclude D9 in
the calculations.
--
intruder9
------------------------------------------------------------------------
intruder9's Profile:
http://www.excelforum.com/member.php...o&userid=30107
View this thread:
http://www.excelforum.com/showthread...hreadid=497946