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