INDIRECT.EXT

D

Danny Lewis

Hi all

I have a function

=SUMPRODUCT((INDIRECT("'[Incidents
period"&RIGHT(AF$3,4)&".xls]DATA'!$G$8:$G$2000")=$C4)*(INDIRECT("'[Incidents
period"&RIGHT(AF$3,4)&".xls]DATA'!$W$8:$W$2000")=$AT$1))

Which as expected, fails when the reference workbook is closed. I downloaded
Morefunc, in an attempt to solve this problem. No, when I change the function
to say:

=SUMPRODUCT((INDIRECT.EXT("'[Incidents
period"&RIGHT(AF$3,4)&".xls]DATA'!$G$8:$G$2000")=$C4)*(INDIRECT.EXT("'[Incidents period"&RIGHT(AF$3,4)&".xls]DATA'!$W$8:$W$2000")=$AT$1))

i.e. just adding .EXT, it returns a #VALUE! error.

Anyone have any idea why this might be???

Kind Regards
Danny
 
Top