All
I have the following formula and works fine:
=SUM(IF(FREQUENCY('[Prod Log Days 060715.xls]A - M'!$A$2:$A$10000,'[Prod Log Days 060715.xls]A - M'!$A$2:$A$10000)>0,1))
Now I need to add Indirect function/, but doesn't work:
=SUMPRODUCT(IF(FREQUENCY(INDIRECT("'" & BasePath & "[Prod Log Days " & CurrentDate & ".xls]A - M'!$A$2:$A$10000, (INDIRECT("'" & BasePath & '[Prod Log Days " & CurrentDate & ".xls]A - M'!$A$2:$A$10000)>0,1))
Could anyone tell me where is wrong or any other alternative?
Many thanks
Regards
Rodrigues
I have the following formula and works fine:
=SUM(IF(FREQUENCY('[Prod Log Days 060715.xls]A - M'!$A$2:$A$10000,'[Prod Log Days 060715.xls]A - M'!$A$2:$A$10000)>0,1))
Now I need to add Indirect function/, but doesn't work:
=SUMPRODUCT(IF(FREQUENCY(INDIRECT("'" & BasePath & "[Prod Log Days " & CurrentDate & ".xls]A - M'!$A$2:$A$10000, (INDIRECT("'" & BasePath & '[Prod Log Days " & CurrentDate & ".xls]A - M'!$A$2:$A$10000)>0,1))
Could anyone tell me where is wrong or any other alternative?
Many thanks
Regards
Rodrigues