Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct help
I am working with 2 worksheets and cannot get the sumproduct to work. I need
to sum quantities from 'Production' worksheet to 'Inventory' worksheet, where criteria in 3 columns of 'Production' matches criteria from 'Inventory'. My formula below is giving me a '0' quantity instead of the actual total of '1440'. Any idea where I am going wrong? =SUMPRODUCT(('[Production.xls]Sheet1'!$B$2:$B$2139=B9)*('[Production.xls]Sheet1'!$G$2:$G$2139=X9)*('[Production.xls]Sheet1'!$I$2:$I$2139=D9)*('[Production.xls]Sheet1'!$D$2:$D$2139)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
sumproduct help | Excel Worksheet Functions | |||
help with sumproduct | Excel Discussion (Misc queries) | |||
Sumproduct #value! | Excel Worksheet Functions |