How To Use COUNTUNIQUE Function in Google Sheets

Last Updated on April 13, 2023 by Jake Sheridan

In this tutorial, you will learn how to use the COUNTUNIQUE function in Google Sheets.

How To Use COUNTUNIQUE Function in Google Sheets

The COUNTUNIQUE function in Google Sheets is an incredibly useful function that you can use to quickly count the number of unique values in a given range of cells. The function avoids counting any duplicate values found in the provided range.

This can be incredibly useful when you’re dealing with large datasets, as it allows you to get an idea of how varied your dataset is.

For example, you might use it to determine the number of unique customers in an order database. Or, you can use it to know how many unique cities your customers are based in. The COUNTUNIQUE function is also often used to determine the number of unique responses in surveys.

In this guide, we will show you how to use the COUNTUNIQUE function in Google Sheets.

How to Count Unique Values in Google Sheets

Here’s how to count unique values in Google Sheets.

Step 1

First, we will decide on the cell to place the result of our COUNTUNIQUE function.

In the example above, we want to return the number of unique products in column B. We’ll use the COUNTUNIQUE function to output the count in cell F1.

Step 2

Type the COUNTUNIQUE function into the selected cell.

Step 3

Add the range you want to count as the sole argument of the COUNTUNIQUE function.

In our example above, we’ve determined that there are 14 unique product codes in column B.

Step 4

Besides providing a cell range, the COUNTUNIQUE value also works when you provide values as individual arguments.

Summary

This guide should be everything you need to start using the COUNTUNIQUE function in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.