In this tutorial, you will learn how to count unique values in Google Sheets.
How To Count Unique Values in Google Sheets
When analyzing spreadsheet data, it’s often important to know how many unique values exist in a certain range.
For example, perhaps you want to know how many different cities are present in a list containing customer data. Or, given a list of user-submitted suggestions, we want to know how many unique suggestions to consider.
Google Sheets provides a few functions that can help you count unique values in a dataset.
In this guide, we will explain how to use these functions to quickly and accurately count the number of unique values in a column.
How To Count All Distinct Values in Google Sheets
Here’s how to count all distinct values in Google Sheets.
First, consider the cell range that you want to count unique values from.
In this example, we want to count all unique credit card types in column C.
Select a blank cell and type “=COUNTUNIQE(“ to start the COUNTUNIQUE function.
Unlike the COUNT function, the COUNTUNIQUE function skips duplicate values when returning the total number of values in the provided argument.
Enter the cell range you want to count as an argument of COUNTUNIQUE.
In this example, we’ll count the number of unique values in cells C2:C25.
Hit the Enter key to evaluate the results.
In this example, we find out that there are 11 unique credit card types in our dataset.
Users may also need to count unique values that meet a particular criteria. If this is the case, we suggest using the function COUNTUNIQUEIFS.
The first argument is similar to the argument seen in COUNTUNIQE. The second and third argument allow users to specify a range and a criteria to check.
In the example above, we want to find all unique values in the field credit_card_type that also have an equivalent amount greater than $1000.
This guide should be everything you need to count unique values in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.