Without a specific example, it's difficult to give you specific help...

Meanwhile, I believe this website will get you headed in the right
direction:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html


I hope that helps.

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=493021