sumproduct formula error

T

Todd

Hi. I am trying to use the sumproduct formula to match names from one
worksheet to another and then copy data if there is a match. My test formula
works but when I put the sheet names in I get VALUE? I know the cells have
matches (at least C5 does). Can someone look and see where I went wrong?


Thanks

Todd

Here is my test formula (which works)
=SUMPRODUCT(--(($G$8:$G$20)=(AT16)),$J$8:$J$20)

And here is the formula with the worksheet names included.
=SUMPRODUCT(--($C$2:$C$500)='[Phoenix-Tucson - CO Sept 2004
VoluntaryProducts.tl.xls]Sept2004'!$C5,'[Phoenix-Tucson - CO Sept 2004
VoluntaryProducts.tl.xls]Sept2004'!$Z$2:$Z$500)
 

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

Formula Error When Sorting 1
Variable Sumproduct Range 6
SUMPRODUCT with If condition 3
Counting cells with SUMPRODUCT and conditionals...? 1
SUMPRODUCT & Wildcards 4
SUMPRODUCT with AVERAGE result 3
Mapping strings to integers 6
Sumproduct help 6

Top