Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct using criteria from 2 worksheets
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct using criteria from 2 worksheets
Check your latest post
-- Max Singapore http://savefile.com/projects/236895 Downloads:23,000 Files:370 Subscribers:66 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct criteria | Excel Worksheet Functions | |||
add two criteria that should not be met to sumproduct | Excel Worksheet Functions | |||
SUMPRODUCT / SUMIF on Multiple Worksheets with Multiple Criteria | Excel Discussion (Misc queries) | |||
SUMPRODUCT with 3 criteria | Excel Discussion (Misc queries) | |||
SUMPRODUCT But With <> Criteria | Excel Worksheet Functions |