Forum Discussion
Solved
COUNTIF returns error in a dynamic array
Hello. I have a formula, and it seems like the last COUNTIF would return "Error in Value", it returns error when it is used in this context. It works when I separate the result part of this LET form...
COUNTIF only works with a range as first argument, not with an array. So COUNTIF(matchesdexcol,matchesdexcol) causes an error.
COUNTIF only works with a range as first argument, not with an array. So COUNTIF(matchesdexcol,matchesdexcol) causes an error.