COUNTIFS with HAS Referencing Another Sheet

Good morning, Community! I'm struggling with a formula and could use some help.

On the **CBO CBA Case Tracker sheet, the Priority populations served column is a multi-select with 21 options. The Priority Populations Served sheet has a Population column with each of the 21 values as I thought it would be easier to reference. On the **CBO CBA Case Tracker sheet, in A or B, I want to count the number of occurrences for each of the 21. Thinking B was the better place, I have space for all 21 but with the current formula, it's returning "0".

To test what the value should be, I filtered the sheet for the first one and there are 20 rows containing the first one (Aging/Older Populations).

What am I doing wrong?

Find more posts tagged with

Accepted answers

APell

I would say try Contains(.

=countif([Priority Population Served]:[Priority Population Served], CONTAINS("Aging/Older Populations",@cell))

That will count the number of times that phrase or word appears in that column. I would suggest summarizing this data on another sheet as the 'sheet summary fields' on the side bar can not be used for very much as far as dashboards and reports go.

All comments

APell

I would say try Contains(.

=countif([Priority Population Served]:[Priority Population Served], CONTAINS("Aging/Older Populations",@cell))

Chris Hallo

Thanks, @APell. This works for the immediate need!

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.