Skip to content
Adaptam Docs

COUNT_UNIQUE_IF

Count of unique numeric values in a range, filtered by one or more conditions. Non-numeric values (text, dates, blanks/empty cells, Booleans, errors) are ignored. Duplicates are counted once.

Function syntax

COUNT_UNIQUE_IF(count_unique_range, filtering_range1, condition1, ...)

Arguments:

  • count_unique_range: The range containing the numeric values to count.
  • filtering_range1: The range to check against condition1.
  • condition1: The value(s) to match in the filtering range.
  • filtering_range2, condition2, …: (optional) Additional filtering range and condition pairs.

Provide the count range first, then pairs of filtering range and condition. All ranges must be single-column and the same height. When multiple conditions are provided, all must match for a value to be counted.

Examples

  • COUNT_UNIQUE_IF(B3:B10, A3:A10, “apple”) - Counts unique numeric values in B3:B10 where A3:A10 is apple.
  • COUNT_UNIQUE_IF(B3:B10, A3:A10, “apple”, D3:D10, ‘1/1/24’..‘1/31/24’) - Counts unique numeric values in B3:B10 where A3:A10 is apple and D3:D10 is within January 2024.