Help with DISTINCT Formula

I need to calculate a value that shows the following:

# of distinct institutions in a column, and out of those distinct institutions, I need to filter out the Global institutions in another column labeled "Territory". Here is what I have come up with, but it is not working:

=COUNTIF(DISTINCT(Institution:Institution), Territory:Territory, NOT(@cell = "Global"))

I saw somewhere that the COUNTIF and COUNTIFS do not work with the DISTINCT value. Is that true? Help!

Find more posts tagged with

Accepted answers

Paul Newcome

It is true. You are gong to need a COUNT/DISTINCT/COLLECT.

=COUNT(DISTINCT(COLLECT(Institution:Institution, Territory:Territory, @cell <> "Global")))

All comments

Paul Newcome

It is true. You are gong to need a COUNT/DISTINCT/COLLECT.

=COUNT(DISTINCT(COLLECT(Institution:Institution, Territory:Territory, @cell <> "Global")))

Tricia Banks

Yep, that did it!! Thank you!

Paul Newcome

Happy to help. 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.