COUNTUNIQUEIFS

Returns the unique count of a range depending on multiple criteria.

Sample Usage

COUNTUNIQUEIFS(A2:A10, B2:B10, ">20")

COUNTUNIQUEIFS(A2:A10, B2:B10, ">20", C2:C10, "<30")

COUNTUNIQUEIFS(A2:A10, D2:D10, "Yes")

Parts of a COUNTUNIQUEIFS function

COUNTUNIQUEIFS(count_unique_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])

Part Description
count_unique_range The range from which the unique values will be counted.
criteria_range1 The range to check against criterion1.
criterion1 The pattern or test to apply to criteria_range1.
Criteria_range2, criterion2, … [OPTIONAL] - Additional ranges and criteria to check.

Notes

  • COUNTUNIQUEIFS will return 0 if none of the criterion are satisfied.
  • count_unique_range and all the criterion ranges must contain the same number of rows and columns.

Examples

Related functions

  • COUNTUNIQUE
  • COUNTIFS
  • IF
  • AVERAGEIFS
  • MAXIFS
  • SUMIFS
Was this helpful?
How can we improve it?
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false