Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct function?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct function?
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct function?
You're welcome. Thanks for the feedback!
Biff "Claudia" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Skipping cells when using SUMPRODUCT function | Excel Discussion (Misc queries) | |||
Summing multiple tab using sumproduct function | Excel Worksheet Functions | |||
use of sumproduct function | Excel Worksheet Functions | |||
Sumproduct function | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |