If more than one row in your spreadsheet can have information on a
particular product, I think you would be better using sumproduct.

If you can be more specific, You will get lots of help.


--
bob777
------------------------------------------------------------------------
bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=504776