Forum Discussion
NicolleNeira
Dec 26, 2022Copper Contributor
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 ...
chezmoi
Dec 26, 2022Copper Contributor
it is usually something like character strings with different lengths and numbers as text on sheet and as numbers on the other
NicolleNeira
Dec 26, 2022Copper Contributor
I see!
Would you suggest changing the wording? I'm trying to get all results with criteria "YES" and "Q1" from my sourcebook.
Would you suggest changing the wording? I'm trying to get all results with criteria "YES" and "Q1" from my sourcebook.
- mathetesDec 26, 2022Silver ContributorAre 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.
- NicolleNeiraDec 26, 2022Copper Contributor
- mathetesDec 26, 2022Silver Contributor
What values are in $D$2:$D$13 and $E$2:$E$13? Can you display an image showing those, blocking out the other fields?
Is it possible that the mismatch is between the data in those columns and the criteria in the formula?