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.
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.
Hans, thank you so much for the prompt response. This definitely solves my issue.
