Countif Distinct and checkbox

Melitta

I have a formula in sheet a (metric sheet), to count if data in a column in sheet b, has distinct information and if a checkbox column also in sheet b, is checked.

=COUNTIF(DISTINCT({Total # of Responses on Distinct Awards},({Curated CRFFAAResponse}, "1")

I'm getting an Incorrect argument error.

Ideas? Is this because the Distinct part doesn't have a range? or something else?

Mark.poole

@Melitta

Try

=COUNTIF(DISTINCT([Total # of Responses on Distinct Awards]:[Total # of Responses on Distinct Awards]),{Curated CRFFAAResponse}, "1")

Melitta

@Mark Poole ,

Thanks, unfortunately the result is the same. The sheet I have is a metric sheet so both references are to the same sheet - different columns.

Paul Newcome

Try this instead:

=COUNT(DISTINCT(COLLECT({Total # of Responses on Distinct Awards}, {Curated CRFFAAResponse}, @cell = 1)))

Melitta

@Paul Newcome Unfortunately, that gives a 1, no matter the information.

Paul Newcome

Can you provide a screenshot of multiple rows that should be getting counted?