Sumproduct function?
Biff,
Thanks a bunch. It works like a charm.
Claudia
"Biff" wrote:
Hi!
If I understand:
A2:A6 =
apples
apples
oranges
peaches
oranges
B1:D1 =
Company x Company y Company z
A10 =
apples
B9 =
Company ?
=SUMIF(A2:A6,A10,INDEX(B2:D6,,MATCH(B9,B1:D1,0)))
Biff
"Claudia" wrote in message
...
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
|