Formulas > =COUNTUNIQUEIFS()

How To Use COUNTUNIQUEIFS() Function in Google Sheets

Description

<div>Returns the unique count of a range depending on multiple criteria.<br><br>Example Usage:<br>COUNTUNIQUEIFS(A2:A10, B2:B10, "&gt;20")<br>COUNTUNIQUEIFS(A2:A10, B2:B10, "&gt;20", C2:C10, "&lt;30")<br>COUNTUNIQUEIFS(A2:A10, D2:D10, "Yes")</div>

How To Actually Use COUNTUNIQUEIFS() in Sheets

<pre>COUNTUNIQUEIFS(count_unique_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])</pre>

2 Better Sheets Tutorials

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.

Asa

Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.