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?