How about removing the N/A's where they occur?? I'm thinking something
like =IF('condition that causes N/A is true',0,'function') in each of
the cells to be summed (B6,B11,B16,...)


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=377157