-1

I want to use count if, only if a value is unique.

I've tried a number of syntaxes starting with countif and countunique, but they all failed so far.

Here's one I've tried:

=COUNTIFS(COUNTUNIQUE('Copy of IMP CRM (for analysis)'!F:F),'Copy of IMP CRM (for analysis)'!I:I,"Phase 1 - Active")
Rajat Jain
  • 1,339
  • 2
  • 16
  • 29
ASE
  • 145
  • 1
  • 1
  • 8

1 Answers1

0

The wording of the question is a bit ambiguous, but I think you may just want

=COUNTUNIQUE(filter(F:F,G:G="active"))
Tom Sharpe
  • 30,727
  • 5
  • 24
  • 37