Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDIRECT.EXT Help Required | Excel Worksheet Functions | |||
INDIRECT.EXT help needed | Excel Worksheet Functions | |||
Problems with PULL function, INDIRECT.EXT and so forth | Excel Worksheet Functions | |||
Data from closed workbooks (pull func, indirect.ext, etc ....) | Excel Worksheet Functions | |||
Problem with updating values with INDIRECT.EXT | Excel Worksheet Functions |