Google Sheets COUNTUNIQUE Function | Count Unique Values | Google Sheets Functions смотреть онлайн

Use the Google Sheets COUNTUNIQUE function to count unique data in a range and or list of values. In contrast, the COUNT function returns the count of numerical data, COUNTIF output is the count of values that meet a single criterion, and COUNTIFS returns the count of values which meet two or more criteria.

----------------------------------------------------
If you are interested in the COUNT, COUNTIF, or COUNTIFS function, here are the links to the video tutorials:

COUNT function tutorial:
https://youtu.be/Yd2lCZB3WfE

COUNTIF function tutorial:
https://youtu.be/ItttED6r9pc

COUNTIFS function tutorial:
https://youtu.be/urrL985PvRk
----------------------------------------------------

The COUNTUNIQUE function requires two attributes, one of which is optional.

Let's look at the format of the COUNTUNIQUE function formula:

=COUNTUNIQUE(value1, [value2])

Start the formula with an equal-to symbol.

COUNTUNIQUE is the name of the function.

value1 is a range or a list of values from which to get a count of unique data.

value2, and other ranges or lists, is optional, and is another range or a list of values.

Note that value1 can be a range and value2 can be a list of values or vice versa.

Here are examples of the Google Sheets COUNTUNIQUE function formula:

Example 1

=COUNTUNIQUE(value1, [value2])

=COUNTUNIQUE(A2:A10)

The above formula will return the count of unique values in the range A2 to A10.

Example 2

=COUNTUNIQUE(value1, [value2])

=COUNTUNIQUE(A2:A10, "fruits")

The output of the above formula will be the count of unique values in the range A2 to A10 plus 1, if fruits is not a value found in the said range.

Example 3

=COUNTUNIQUE(value1, [value2])

=COUNTUNIQUE("vegetables", "fruits", "grains", "confectioneries", "dairy", "vegetables")

The above formula will return 5, because one item is a duplicate item.

Take a look at this video tutorial, which gives the steps to use the Google Sheets COUNTUNIQUE function with an example.