Counting Unique Values Based on Request Type.

I am trying to use a COUNTIFS formula to count the total number of unique Request IDs with the Request Type as "Other" on a separate sheet. I keep getting a value of "0" when it should be "2". Any help is appreciated!

The formula I am using is: =COUNTIFS({Completion Updates Range 7}, ="Other", {Completion Updates Range 10}, COUNT(DISTINCT({Completion Updates Range 10})))

Completion Updates Range 7 is the Type of Request column

Completion Updates Range 10 is the Request ID column.

Find more posts tagged with

Accepted answers

Ryan Sides

Hey @Brett Hughes , You're on the right track. We need to use COUNT DISTINCT COLLECT function combo...

=COUNT(DISTINCT(COLLECT({Completion Updates Range 10}, {Completion Updates Range 7}, "Other")))

So this says, count the distinct values of Request ID when Type of Request is Other.

Here's a related video that might help too.

All comments

Ryan Sides

Hey @Brett Hughes , You're on the right track. We need to use COUNT DISTINCT COLLECT function combo...

=COUNT(DISTINCT(COLLECT({Completion Updates Range 10}, {Completion Updates Range 7}, "Other")))

So this says, count the distinct values of Request ID when Type of Request is Other.

Here's a related video that might help too.

Brett Hughes

That worked perfectly! Thank you!

Ryan Sides

You bet! 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.