I have a list of values on a sheet, with Product code in column 1 and sales quantity in sales 2.

On a separate summary sheet, I need to add up products in a variety of combinations.

I was thinking of using SUMPRODUCT, but I can't get it to work. I want something like this

=sumproduct(--('Data Sheet'A1:A65000=or(A1:A7),'Data Sheet'B1:B65000))

Does anybody have any bright ideas?

Many thanks,

Chris