Forum Discussion
Sumifs using external links returning #VALUE unless source file open
I am using the multiple criteria sumifs on external workbooks and the result is #VALUE unless I have the source file open. I have tried refreshing the data to no effect, it seems to require the file...
Haytham Amairah Hi Haytham. Ive tried using SUMPROD but still no success. the sum_range i have included last (array 3). is there something that i am missing?
arshadtape I came across the same issue but I Used Index Match Formula to get results that I want from the closed external workbook.