I would like to count the total values from a multi select column, based on another columns criteria

Jeremy J.

I apologize but I cannot seem to wrap my head around this.

My goal is to count the total values in a multi select column based on another columns criteria.

I figured I could combine the use of CountM and CountIFS but I have not been successful.

Here is an example.

The goal is for me to determine the total # of Reps Per Manager.

There are about a 400 unique Reps, this is just a cleaned up example.

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You would use a COUNTM/COLLECT combo.

=COUNTM(COLLECT(Rep:Rep, Manager:Manager, @cell = [Manager (For Formula)]@row))

All comments

Paul Newcome

You would use a COUNTM/COLLECT combo.

=COUNTM(COLLECT(Rep:Rep, Manager:Manager, @cell = [Manager (For Formula)]@row))

Jeremy J.

I was about to do a work around using a helper column but your suggestion worked. 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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.