Google Sheets

COUNTUNIQUE: Google Sheets Formulae Explained

How do you use COUNTUNIQUE in Google Sheets?

The COUNTUNIQUE function in Google Sheets counts the number of unique values in a selected range. This function is useful for identifying and counting the unique values in a data set, or for counting the number of unique items in a list. To use the COUNTUNIQUE function, select the range of cells that contains the data set or list, and then enter the COUNTUNIQUE function into the Formula bar. The function takes two arguments: the range of cells to be counted and the type of comparison to be used. The comparison can be one of the following: "equal to", "not equal to", "greater than", "less than", "between", or "in".

What is the syntax of COUNTUNIQUE in Google Sheets?

The syntax of COUNTUNIQUE in Google Sheets is COUNT(DISTINCT()) . This function counts the number of unique values in a given range.

What is an example of how to use COUNTUNIQUE in Google Sheets?

The COUNTUNIQUE function in Google Sheets can be used to count the number of unique entries in a given range. For example, if you have a list of names in a column, you can use COUNTUNIQUE to count the number of unique names in the list. You can also use COUNTUNIQUE to count the number of unique entries in a list of numbers, or a list of strings.

When should you not use COUNTUNIQUE in Google Sheets?

There are a few occasions when COUNTUNIQUE should not be used in Google Sheets. One example is when you are trying to count the number of unique items in a range of cells that contain text values. In this case, COUNTUNIQUE will not work because it counts the number of unique items based on the text values in the cells, not on the actual item counts. For example, if you have the text values "A", "A", "B", "B", "C", "D" in a range of cells, COUNTUNIQUE will return a value of 3 even though there are only 2 unique items in the range.

What are some similar formulae to COUNTUNIQUE in Google Sheets?

There are a few similar formulae that can be used in Google Sheets to count unique values in a range of cells. The COUNTIFS function can be used to count the number of unique values in a range of cells that match a specific set of criteria. The COUNT function can be used to count the number of unique values in a range of cells. The DISTINCT function can be used to count the number of unique values in a range of cells.

Move beyond 

Google Sheets

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.