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 ...
mathetes
Dec 26, 2022Silver Contributor
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.
NicolleNeira
Dec 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?
- NicolleNeiraDec 26, 2022Copper Contributor
mathetes Sure 🙂 here is the data.
I verified a couple of times to see if there were something mistyped, but couldn't locate any error on the file 😞
- mathetesDec 26, 2022Silver Contributor
Nothing pops out at me.
I did wonder if you've tried plain COUNTIF (with out the "S" on the end).
Also I'm wondering whether you have a new enough version of Excel for the FILTER function to work? It requires 2021 or newer, or the Microsoft 365 subscription.
FILTER can work with multiple criteria and can be nested within a COUNT or COUNTA formula. Here's a YouTube video that introduces FILTER and some other dynamic array functions.