In workbook 1, I have a table with data from various companies:

Company x Company y Company z
apples
apples
oranges
peaches
oranges

In workbook 2, I have the following summary table:

Company ?
apples
oranges
peaches

How do I sum for the values in colum a based on the company name I put at
the head of column b? I have tried a sumproduct formula but I keep getting a
#value error.

Thanks
Claudia