How To Use COUNTUNIQUEIFS()

Description

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

Example Usage:
COUNTUNIQUEIFS(A2:A10, B2:B10, ">20")
COUNTUNIQUEIFS(A2:A10, B2:B10, ">20", C2:C10, "<30")
COUNTUNIQUEIFS(A2:A10, D2:D10, "Yes")

How To Actually Use COUNTUNIQUEIFS() in Sheets

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

0Better Sheets Tutorials

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Find more formulas here at Better Sheets.

Learn more about the COUNTUNIQUEIFS() formula: