The main problem I see is that your ranges don't match up.
Your firt range is A2:A8, which is a total of seven cells. Your second
range is X1:X10 (a total of 10 cells). Then your third range is a total of
9 cells.
Note: Your ranges don't necessarily have to be the same exact rows, but the
number of cells in each range need to be the same.

May be it should be:
=SUMPRODUCT(--(A2:A10=X2:X10),(X2:X10))

HTH,
Paul

--

"vito" wrote in message
...
I have a table of data for multiple types of products manufactured over a
period of time.
X Y Z
Product a b c ...
5 2 3
0 8 11

I am grouping these products in another area
A B C
Group 1 Group 2 Group 3
a b d
c e g
...

What I want to do is based on the group look up the product and some the
number of batches made. I am trying to do a
sumproduct(--(A2:A8=X1:X10),(X2:X10)) however this returms a #VALUE!. I
am
assuming because I am trying to search for multiple products instead of 1.
Any help would be great.

Thanks