Count formula for Multi Select AND checkbox

Hi!

I am currently looking to see if there is a formula that will give me a count outcome based on

1) A certain text in a multi select drop down (language)

PLUS

2) if a checkbox is ticked for that same row

So I am looking for the total of number of "Specific Language Speakers" in a multi select with a checkbox ticked in the same row but seperate column

Can anyone help I've had a few goes at it and its really not coming to fruition :)

Find more posts tagged with

Accepted answers

Dan W

=COUNTIFS(Multiselect:Multiselect, HAS(@cell, "Specific Language Speakers"), CheckBox:CheckBox, =1)

All comments

Dan W

=COUNTIFS(Multiselect:Multiselect, HAS(@cell, "Specific Language Speakers"), CheckBox:CheckBox, =1)

Dan_H

This is unbelievably helpful issue resolved thank you!!!!

Dan W

Excellent glad to help!

NBW501

Hi! I am looking for a formula to solve the same issue: multi-select dropdown and a another column with a checkbox, but I'm getting an "Invalid" result. Can anyone tell what isn't working in my formula below?

=COUNTIFS({Weekly Social Content Calendar: Q2 2024 Range 2}, HAS(@cell, [Primary Column]@row), {Weekly Social Content Calendar: Q2 2024 Range 1,=1})

—- please disregard. I just started from scratch and rearranged the formula, and it worked!

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.