Forum Discussion
Solved
Trying to use UNIQUE inside COUNTIF
Hi! Im getting the kind of error you get when there's a sintax error in a formula when I try to use UNIQUE inside COUNTIF. What I have is a column (S) that's concatenating month (column A) with sel...
UNIQUE returns an array. The first argument of COUNTIF must be a range, not an array.
See Count unique values with criteria for a way to do this.
Just in case there is anything of interest, here is the file showing differing levels of complexity.