Maybe wrap-around.
Try copying
=SUMPRODUCT(--('Stock Issues'!G2:G200=$A$1),
--('Stock Issues'H2:H200=B1),'Stock Issues'F2:F200)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"1990" wrote in message
...
Thanks for the reply, but when i copy that in it brings up an error
message and highlights the second 'Stock - highlighted in red here "
=SUMPRODUCT(--('Stock Issues'!G2:G200=B1),--('Stock
Issues'H2:H200=$A$1),'Stock Issues'F2:F200) "
--
1990
------------------------------------------------------------------------
1990's Profile:
http://www.excelforum.com/member.php...o&userid=30100
View this thread: http://www.excelforum.com/showthread...hreadid=497851