COUNTIF and COLLECT

If the column "Graduation Year" is "2021", I want to collect from the column "Position TYPE Post GME Training" the total number of cells with "Private Clinical Practice-local". See below. What am I doing wrong?🤔 There are multiple values in addition to "Private Clinical Practice-local" in the dropdown for "Position TYPE Post GME Training" and I'll need to collect a total for each value. Appreciate your help.

=COUNTIF([Graduation Year]:[Graduation Year](COLLECT([Position TYPE Post GME Training]:[Position TYPE Post GME Training], @cell=Private Clinical Practice local,"2021"))

Find more posts tagged with

Accepted answers

Mark Cronk

Hi Barbara,

Does this get you what you're looking for?

=COUNTIFS([Graduation Year]:[Graduation Year], 2021, [Position TYPE Post GME Training]:[Position TYPE Post GME Training], HAS(@cell, "Private Clinical Practice local"))

Mark

All comments

Mark Cronk

Hi Barbara,

Does this get you what you're looking for?

=COUNTIFS([Graduation Year]:[Graduation Year], 2021, [Position TYPE Post GME Training]:[Position TYPE Post GME Training], HAS(@cell, "Private Clinical Practice local"))

Mark

Barbara Wanciak

Thank you Mark! It worked! Last night I figured out this worked as well. (see below).

COUNTIFS([Graduation Year]:[Graduation Year], "2021", [Position TYPE Post GME Training]:[Position TYPE Post GME Training], @cell="Private Clinical Practice local")

Barbara

Mark Cronk

Excellent. Glad you found an answer. Thank you for contributing to the Community.

Mark

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.