Forum Discussion
GhostCrab
Aug 05, 2025Copper Contributor
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...
Patrick2788
Aug 05, 2025Silver Contributor
You can swap COUNTIF for an array friendly GROUPBY:
DROP(GROUPBY(matchesdexcol, matchesdexcol, COUNTA, , 0), , 1)