Formulas > =COUNTUNIQUEIFS()

How to Use COUNTUNIQUEIFS() in Google Sheets

Description

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

How To Actually Use COUNTUNIQUEIFS() in Sheets 

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

Try COUNTUNIQUEIFS yourself

Use COUNTUNIQUEIFS to count unique values in A2:A10 where B2:B10 is greater than 20. Place the formula in D2.

Hints (3)
Separator ,
Official Docs

Better Sheets Tutorial

Count Unique Attendees For Each Event

Count Unique Attendees For Each Event

Find out how many people attended each event even if they are double counted in attendee lists.
Beginner
COUNTUNIQUE() COUNTUNIQUEIFS() FILTER() SUM() UNIQUE()
Use COUNTUNIQUEIFS Multiple Conditions to Count Weekdays of Sales

Use COUNTUNIQUEIFS Multiple Conditions to Count Weekdays of Sales

Analyze sales with COUNTUNIQUEIFS Formula. 
Intermediate
COUNTA() COUNTUNIQUEIFS() FILTER() TEXT() UNIQUE()

More related tutorials

Transcript-matched member videos for COUNTUNIQUEIFS(). Click through to watch.

Watch more tutorials
3 More Ways to Count in Google Sheets

3 More Ways to Count in Google Sheets

Learn how to use CountBlank() and more counting formulas.
Beginner
COUNTBLANK() COUNTIFS() COUNTUNIQUE()
3 Ways to Count in Google Sheets

3 Ways to Count in Google Sheets

The video explains three ways to count cells or information in Google Sh...
Beginner
COUNTA() COUNTIF()
Hardest Formula: SumIF | Addition Based on Dates / Values

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...
SUMIF() UNIQUE()
Duplicate Everything For Each Unique Value

Duplicate Everything For Each Unique Value

Great use of SPINTAX.  Get the Google Sheet Add-on; SPINTAX for free.
Intermediate
ARRAYFORMULA() CONCATENATE() JOIN() SPLIT()
Unlock these tutorials

Learn more about the COUNTUNIQUEIFS() formula:

Generate a COUNTUNIQUEIFS() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses COUNTUNIQUEIFS(). 2 free AI generations, no signup. Members get unlimited use.

Generate a COUNTUNIQUEIFS() formula

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Explore

Academy

Tools

Add ons