How To Use COUNTUNIQUEIFS() Function in Google Sheets

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, ...])

Google Docs Help

2 Better Sheets Tutorials

Count Unique Attendees For Each Event

Find out how many people attended each event even if they are double counted in attendee lists.

Beginner

COUNTUNIQUEIFS() UNIQUE() COUNTUNIQUE() SUM() FILTER()

Use COUNTUNIQUEIFS Multiple Conditions to Count Weekdays of Sales

Analyze sales with COUNTUNIQUEIFS Formula.

Intermediate

TEXT() COUNTUNIQUEIFS() COUNTA() FILTER() UNIQUE()

Learn more about the COUNTUNIQUEIFS() formula:

Generate a COUNTUNIQUEIFS() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.

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

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons