COUNTUNIQUE in Google Sheets
Counts how many different values a range holds. Empty cells are not counted.
Syntax
COUNTUNIQUE(value1, [value2], ...)- value1
- The first range or value.
- value2 (optional)
- More ranges or values.
Examples
E1=COUNTUNIQUE(A2:A6)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Rep | Amount | 3 | |
| 2 | North | Ann | 120 | ||
| 3 | South | Bo | 80 | ||
| 4 | North | Cy | 200 | ||
| 5 | West | Di | 50 | ||
| 6 | South | Ed | 150 |
E1=COUNTUNIQUE(B2:B6)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Rep | Amount | 5 | |
| 2 | North | Ann | 120 | ||
| 3 | South | Bo | 80 | ||
| 4 | North | Cy | 200 | ||
| 5 | West | Di | 50 | ||
| 6 | South | Ed | 150 |