Countif Distinct and checkbox

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?

Find more posts tagged with

Accepted answers

All comments

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.