Formulas > =COUNTUNIQUE()
How to Use COUNTUNIQUE() in Google Sheets
Description
How To Actually Use COUNTUNIQUE() in Sheets
COUNTUNIQUE(value1, [value2, ...])
Try COUNTUNIQUE yourself
Use the COUNTUNIQUE formula to count the unique values in the range A1:A10. Your answer should return a single number representing the count of unique entries.
Hints (2)
-
Think about how to specify the range of cells you want to analyze.
-
Remember, COUNTUNIQUE only needs the range as its argument.
2 Better Sheets Tutorials
3 More Ways to Count in Google Sheets
Learn how to use CountBlank() and more counting formulas.
COUNTBLANK()
COUNTIFS()
COUNTUNIQUE()
Count Unique Attendees For Each Event
Find out how many people attended each event even if they are double counted in attendee lists.
COUNTUNIQUE()
FILTER()
SUM()
UNIQUE()
Learn more about the COUNTUNIQUE() formula:
Generate a COUNTUNIQUE() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses COUNTUNIQUE(). 2 free AI generations, no signup. Members get unlimited use.
Generate a COUNTUNIQUE() formula