| 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 |
| 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 | |||
Threaded Mode
