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")