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.
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.