countifs from a multi-select to count two items

I have a multi-select field with 3 items (ex: A, B, C). I want to be able to get a count for 1) cells with A and B and 2) cells with all (a, b, c). Running into trouble.

I've tried: =COUNTIFS({acct type}, "Signed Account", {Product}, "Zonehaven" + COUNTIFS({acct type}, "Signed Account", {Product}, "GEM"))

Find more posts tagged with

Accepted answers

All comments

Not clear what your a,b,c items are but I'm guessing it's the Zonehaven, GEM and some other item. You can alter the formulas below to get what you need.

=COUNTIFS([acct type]:[acct type], "Signed Account", Product:Product, AND(HAS(@cell, "Zonehaven"), HAS(@cell, "GEM")))

=COUNTIFS([acct type]:[acct type], "Signed Account", Product:Product, AND(HAS(@cell, "Zonehaven"), HAS(@cell, "GEM"), HAS(@cell, "C")))

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.