0

I have two excel files. My named range data is located in file 1, and the result should be retrieved from file 2.

How do I link named range from file 1 to file 2 using the equation below?

'2015'!$B$2:$B$19 = should be link to the name range "kshc2013D)

'2015'!$A$2:$A$19 = should be link to the name range "kshc2013A)

=SUMPRODUCT(('2015'!$B$2:$B$19=Count!A2)*('2015'!$A$2:$A$19=1))

3
  • Different workbooks? Not worksheets? You need to include the workbook as a full file path [c:\\my\file\excel.xls]Sheet1!kshc2013D Jun 3, 2015 at 9:15
  • do I need to manually type the link in the formula?
    – Myk
    Jun 3, 2015 at 9:23
  • If you use the formula builder you should be able to click it Jun 3, 2015 at 9:30

1 Answer 1

1

If you're trying to reference a different workbook, not worksheet you need to include the file location in the formula kb. e.g.

=SUMPRODUCT(([C:\my\files\file1.xls]2015!kshc2013D=[filepath]count!A2)*([C:\my\files]file2.xls2015!kshc2013A))

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .