Just wanted to say thanks. I tried the alternative but this sheet will be
used for a lot non savy excel people so that won't work. I am going to
attack the source. Thanks again.

"daddylonglegs" wrote:


Rob,

In your previous thread you said you had #N/As in column I. SUMPRODUCT
doesn't ignore these.

You can try to eliminate these by altering the formula in I - what
formula is that? - or you can try a SUM/IF formula which needs to be
confirmed with CTRL+SHIFT+ENTER as I proposed here

http://www.excelforum.com/showthread.php?t=510776


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=511535