I have a spreadsheet with the following values for `A1:A8`

:

```
1 1 1 2 3 3 4 5
```

I want to count the number of unique values `>= 3`

. (The values aren't guaranteed to be sequential or with uniform step sizes)

This would seem trivial using `UNIQUE()`

, but oddly doesn't work.

If I set `B1`

to `=UNIQUE(A1:A8)`

, the result is a new column with the values we'd expect

```
1 2 3 4 5
```

However, if I then set `C1`

to `=COUNTIF(UNIQUE(A1:A8), ">=3")`

, I get the standard syntax error:

```
There's a problem with this formula.
Not trying to write a formula?
[...]
To get around this, type an apostrophe ( ' ) first
[...]
```

Obviously, if I remove the call to `UNIQUE()`

(`=COUNTIF(A1:A8, ">=3")`

), everything works. I just get the wrong result, since it obviously counts the two `3`

's.

Trying to see if the problem is with `UNIQUE()`

, I tried replacing `COUNTIF()`

with `AVERAGE()`

(`=AVERAGE(UNIQUE(A1:A8))`

), but that works.

Is this expected behavior?