Count Unique IFS New Formula In Google Sheet

Count Unique IFS New Formula In Google Sheet

The COUNTUNIQUEIFS function is not a built-in function in Google Sheets, but you can use a combination of functions to achieve the same result. Here's an example of a formula that counts the number of unique values in a range that meet specific criteria:

less
=COUNTUNIQUE(FILTER(A1:A10, (B1:B10="Category 1")*(C1:C10>10)))

In this formula, the FILTER function is used to extract the values in the range A1:A10 that meet the criteria of "Category 1" in column B and a value greater than 10 in column C. The * operator is used as a logical AND to combine the two criteria. The resulting filtered list is then passed to the COUNTUNIQUE function to count the number of unique values.

Note that this formula assumes that the range A1:A10 contains only one instance of each unique value. If there are duplicate values in the range, the COUNTUNIQUE function will not count them, and the resulting count may be lower than expected.