Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum product with criteria from 2 wkshts
I have been using an array that all of the sudden I can't get to work at
all. I am working with 2 worksheets (with data queries). Where the product code and Plant matches in both worksheets, I want to add the sum of cases from wksht B to wksht A. Can someone tell me what I am doing wrong? My formula looks like this =SUMPRODUCT(('[Production Data-Inv Report.xls]PRODUCTION DATA'!$C$2:$C$1000=B6)*('[Production Data-Inv Report.xls]PRODUCTION DATA'!$G$2:$G$1000=E6)*('[Production Data-Inv Report.xls]PRODUCTION DATA'!$D$2:$D$1000)) Where '[Production Data-Inv Report.xls]PRODUCTION DATA' equals wksht B. Right now I am getting a 0 in every cell. if WKSHT "A" B E L Prod Code Plant On Order SAMPLE SKO 08608-6508 TNB 09400-7864 ADV 09449-6629 ADV WKSHT "B" B D G PROD_CODE CASES PLANT 08608-6508 1632 TNB 08608-6508 2160 TNB 09400-7864 720 ADV 09449-6629 720 ADV |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for product based on criteria? | Excel Worksheet Functions | |||
product between two dates and with criteria | Excel Worksheet Functions | |||
SUMIF/PRODUCT with multiple Criteria not working | Excel Discussion (Misc queries) | |||
SUMPRODUCT, two criteria (date and product type) | Excel Worksheet Functions | |||
Product of 2 arrays based on criteria | Excel Discussion (Misc queries) |