Forum Discussion
CountIFS For Linked workbook
Hello, I'm trying to bring some data using the "CountIFS" formula into linked books, but the formula seems to don't work; it returns results 0. Still, it should reflect 1+, I was reading a bit, and ...
Some functions cannot retrieve data from a closed workbook. COUNTIFS is among the functions requiring the external workbook be open.
Functions that Can Access Closed Workbooks (Microsoft Excel) (tips.net)
Thank you,
But both books are open while I'm working on them, "Sourcebook" is active.
But both books are open while I'm working on them, "Sourcebook" is active.