Formula assistance - multi select column and a not blank column

Hi! In a multi-select column, I'm trying to count the number of specific criteria and another column that is not blank. Both must be met and I'm unfortunately seeing an error message. Any suggestions? Thank you!

=COUNTIFS([Format Type]:[Format Type], HAS(@cell, "Live - Symposium"), [Format Type]:[Format Type], HAS(@cell, "Live - Congress"), [Approved 2024 $$]:[Approved 2024 $$], NOT(ISBLANK(@cell)))

Find more posts tagged with

Accepted answers

Leibel S

Did you want to check for either Live - Symposium or Live - Congress then you would need:

=COUNTIFS([Format Type]:[Format Type], OR(HAS(@cell, "Live - Symposium"), HAS(@cell, "Live - Congress")), [Approved 2024 $$]:[Approved 2024 $$], NOT(ISBLANK(@cell)))

All comments

cvirden

Sorry, this is the formula:

Leibel S

What is the error?

cvirden

Apologies, I was trying a trying a few different changes to the formula and the other version was giving me #INCORRECT ARGUMENT SET. The formula posted is technically "working" but it's giving me a result of "1". It should be a higher number than that.

Leibel S

Did you want to check for either Live - Symposium or Live - Congress then you would need:

=COUNTIFS([Format Type]:[Format Type], OR(HAS(@cell, "Live - Symposium"), HAS(@cell, "Live - Congress")), [Approved 2024 $$]:[Approved 2024 $$], NOT(ISBLANK(@cell)))

cvirden

That did it! Thank you so much for your help!

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.