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