INDIRECT.EXT
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 |
All times are GMT +1. The time now is 05:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com