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
 

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

Top