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 ...
That's why I suggested the COUNT(FILTER) combination as ideal
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)