Formulas > =COUNTUNIQUE()

How To Use COUNTUNIQUE() Function in Google Sheets


Counts the number of unique values in a list of specified values and ranges.

Common questions about the COUNTUNIQUE formula include:
What does COUNTUNIQUE do? How does COUNTUNIQUE work?

The COUNTUNIQUE formula can be used appropriately to count the number of unique values in a range or array of values, ignoring any duplicates.

The COUNTUNIQUE formula can be commonly mistyped as COUNTNUNIQUE or COUNTUNIQUEY.

Some common ways the COUNTUNIQUE formula is used inappropriately include trying to use it to count the total number of entries in a range, including duplicates, and to count the occurrences of a particular value.

Common pitfalls when using the COUNTUNIQUE formula include not realizing that if a range contains blank cells, these are not considered unique values and will therefore be excluded from the final count.

Common mistakes when using the COUNTUNIQUE Formula include forgetting to include the range as an argument.

Common misconceptions people might have with the COUNTUNIQUE Formula include believing that COUNTUNIQUE will count the unique number of rows, rather than the number of unique values.

How To Actually Use COUNTUNIQUE() in Sheets

COUNTUNIQUE(value1, [value2, ...])

2Better Sheets Tutorials

Learn how to use CountBlank() and more counting formulas.
Find out how many people attended each event even if they are double counted in attendee lists.

Learn more about the COUNTUNIQUE() formula:

Generate a COUNTUNIQUE() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.