Countifs formula help for multiple dropdown selections

I am attempting to count different dropdown selections that have historically been amended. For example, where dropdown options were "Multi"; "M/A" but is now "Multi-Account", I need to count all 3 potential selections for a single year.

Where a single value has always existed, this is the formula I'm using:

=COUNTIFS({Master Sheet - Mentor Requests Range 7}, CONTAINS("Multi-Account",@cell), {Reporting Year}, "2022")

Thanks

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Do you mean you are trying to count cells that contain either "Multi", "M/A", or "Multi--Account?

Vicki Diaper

Yes that's correct.

Paul Newcome

Ok. Try this...

=COUNTIFS({Master Sheet - Mentor Requests Range 7}, OR(CONTAINS("Multi",@cell), CONTAINS("M/A",@cell)), {Reporting Year}, "2022")

I only specified "Multi" and "M/A" because "Multi" will also grab "Multi-Account"

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.