countif(distinct(

lisalettieri

=COUNTIF(DISTINCT({Case Consultation Tracker Advisor Namex}, {Case Consultation Tracker Advisor Namex}, {Case Consultation Tracker Meeting Number}, =1))

Trying to count Avisor Namex if the same is unique AND Meeting Number is 1. Coming back with INCORRECT ARGUMENT.

Help needed.

Lisa

Kelly Moore

Hey @lisalettieri

Just to clarify that this was the formula you tried with Collect:

=COUNT(DISTINCT(COLLECT({Case Consultation Tracker Advisor Namex},{Case Consultation Tracker Meeting Number}, =1)))

Does this work for you?

Kelly

lisalettieri

I tried it with COLLECT but that didn't work either. BTW I'm referencing another sheet.

Kelly Moore

Hey @lisalettieri

Just to clarify that this was the formula you tried with Collect:

=COUNT(DISTINCT(COLLECT({Case Consultation Tracker Advisor Namex},{Case Consultation Tracker Meeting Number}, =1)))

Does this work for you?

Kelly

lisalettieri

This worked, thanks! Count the unique values in the 1st field if meets 2nd field criteria.

=COUNT(DISTINCT(COLLECT({Case Consultation Tracker Advisor Namex}, {Case Consultation Meeting Number}, =1)))