*70*

Often you may want to count the number of unique values in Google Sheets.

Fortunately this is easy to do using the **COUNTUNIQUE()** function.

The following examples show how to use this function in practice.

**Example 1: Count Unique Values in One Column**

The following screenshot shows how to use the **COUNTUNIQUE()** function to count the number of unique team names in column A:

There are **6** unique team names in column A.

**Example 2: Count Unique Values in Multiple Columns**

The following screenshot shows how to use the **COUNTUNIQUE()** function to count the number of unique team names in column A and column B:

There are **13** unique team names in column A and column B.

**Example 3: Count Occurrences of Unique Values**

To count how often each unique value occurs, you can first use the **UNIQUE()** function to display a list of unique team names:

You can then use the **COUNTIF()** function to count how often each unique team name occurs in column A:

From the output we can see:

- Mavericks occurs
**2**times. - Hornets occurs
**3**times. - Nets occur
**1**time.

And so on.

**Additional Resources**

The following tutorials explain how to perform other common operations in Google Sheets:

How to Calculate Frequencies in Google Sheets

How to Sum Values by Category in Google Sheets

How to Count Number of Occurrences in Google Sheets