The COUNTUNIQUE function in Google Sheets is an invaluable tool for data analysis, specifically designed to count the distinct values contained in a specified range or list. This function is particularly useful for identifying unique entries in datasets, aiding in tasks such as inventory management, survey analysis, or any scenario where determining the number of unique items is necessary.

Syntax

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

• value1: The first range or value to evaluate for uniqueness.
• value2: (Optional) Additional ranges or values to include in the uniqueness check.

Example #1

=COUNTUNIQUE(A1:A10)

This function counts all unique values in the range A1 to A10. For instance, if A1 to A10 contains the values {1, 2, 2, 3, 4, 4, 4, 5}, it will return a result of 5, as there are five distinct numbers.

Example #2

=COUNTUNIQUE(B1:B5, C1:C5)

This function evaluates and counts unique values across both ranges B1 to B5 and C1 to C5. If B1 to B5 contains {apple, banana, banana} and C1 to C5 contains {orange, apple}, the function will return 4, considering the unique items: {apple, banana, orange}.

Example #3

=COUNTUNIQUE(D1:D20)

This function will count the unique entries found in the range D1 to D20. For example, if D1 to D20 comprises the values {x, y, y, z, z, z, x, w}, it will yield a result of 4, indicating that there are four unique items: {x, y, z, w}.

Error handling

• VALUE! This error appears when the provided values or ranges are of incompatible types or if the input is not recognized.
• REF! This error indicates a reference issue, such as when the cell range being referenced has been deleted.
• NUM! This error occurs when a function’s input is invalid or out of acceptable range.

Conclusion

In summary, the COUNTUNIQUE function is a powerful feature in Google Sheets that simplifies the process of identifying unique values within specified ranges or lists. By accurately counting distinct entries, users can save time during data analysis and gain clearer insights into various data sets. Understanding and applying this function effectively can enhance your data handling capabilities, making it an essential tool for both casual users and data professionals.