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
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