sumproduct using criteria from 2 worksheets

B

brownmre

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sumproduct using criteria from multiple columns in a separate wksh 1
sum product with criteria from 2 wkshts 3
Compare worksheets for duplicates and copy data to 1st worksheet 2
counting multiple criteria using SUMPRODUCT and getting #VALUE err 1
Lookup using multiple sheets and multiple criteria, sorry if 2 pos 4
SUMPRODUCT - (amended) Exclude LAST Row of Matched Criteria (Month & Year) 2
Best way to populate worksheet from 2 combo boxes 0
matching 2 worksheets together 1

Top