Forum Discussion
sumproduct on a closed workbook with dynamic sheet and file names
Thanks for reading. I'm using the sumproduct function to https://www.excelforum.com/excel-formulas-and-functions/1060824-sumifs-returning-value-on-closed-workbook.html This works fine: =SUMPRODUCT...
Unfortunately, the INDIRECT function does not support references to closed workbooks...
Thanks.
I suppose there is no other way to accomplish this?
Using the &" "& concatenation doesn't seem to work.
No, INDIRECT won't work whichever way you try.