Google Sheets functions / Math
Math function · Google Sheets
COUNTUNIQUE function
Counts unique values.
Availability
| Platform | Status |
|---|---|
| Excel | Not listed |
| Google Sheets | Listed |
On Excel: use COUNTA. Use =COUNTA(UNIQUE(range)) in modern Excel.
Reference entry. Syntax, tested examples and a practice file arrive with the full guide. Open the official function list.