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 it looks like I should replace the formula with another different, any ideas?
- it is usually something like character strings with different lengths and numbers as text on sheet and as numbers on the other
- I see!
Would you suggest changing the wording? I'm trying to get all results with criteria "YES" and "Q1" from my sourcebook.- Are you able to share the formula(s) you're using, the one(s) that don't work as desired? Even if you can't share the workbook itself, seeing the actual formula could help in our shared diagnosis.
- You need to explain more fully what the column contains are that you're seeking to count. Ideally, post a copy of the workbook on OneDrive or GoogleDrive and paste a link here that grants edit access. Your current description is too brief for anybody to offer any specific advice.
Thanks for the recommendation; since this is a corporate document, I cannot share it publicly, but I will try to provide more details!
I have a Workbook with information filled by our team members ("Sourcebook"); I want that information in a different Excel book ("Destination book") for management purposes, so I created a new file to include the information entered by the team within the same shared online folder.
When I'm trying to feed the "destination book" from "Sourcebook" with formulas such as CountIFS it returns a #VALUE error. I checked all data in the "source book" and couldn't identify any mistakes.
I also used formulas like Sum(SumIFS, Sum(If as per microsoft community recommendations. (https://learn.microsoft.com/en-us/office/troubleshoot/excel/formula-returns-value-error)
Thanks in advance for any help you could provide.
Regards,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)
