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))
[c:\\my\file\excel.xls]Sheet1!kshc2013D