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
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.
NicolleNeira
Dec 26, 2022Copper Contributor
Thanks for the guidance and advices, just wondering if COUNTIF will provide the results I need, since I'm adding two different criteria!
Thank you
Thank you
- mathetesDec 27, 2022Silver Contributor
See the attached example of both a COUNT and a SUM with a FILTER function nested within. Assuming you have software that can handle these "dynamic array functions" you can change the entries in the yellow cell to see how the formulas respond. You can also extend the table, by just adding rows, to see how it will continue to track. (keep the same range of values in those two columns)
- mathetesDec 26, 2022Silver ContributorThat's why I suggested the COUNT(FILTER) combination as ideal