Struggling to String together the correct COUNTIFS

Hello There Community

I need help with stringing variables together

I am using the following formula: =COUNTIFS({GDS}, "Sabre", {Status}, "Open", {Airline}, (CONTAINS ("AA", (OR ("ALL")))))

Everything works up until {Airline} which is the sheet reference

Essentially I want to return the count if the cell contains either AA or ALL or Both

Currently getting unparseable.

Help is greatly appreciated.

Thanks

Garry

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Try this instead:

=COUNTIFS({GDS}, "Sabre", {Status}, "Open", {Airline}, OR(CONTAINS ("AA", @cell), CONTAINS("ALL", @cell)))

Garry McEwen

@Paul Newcome

Copied and pasted - =COUNTIFS({GDS}, "Sabre", {Status}, "Open", {Airline}, OR(CONTAINS ("AA", @cell), CONTAINS("ALL", @cell)))

Cell still comes back Unparseable 😫

Garry McEwen

Have managed to fix it

=COUNTIFS({GDS}, "Sabre", {Status}, "Open", {Airline}, OR(@cell = "AA", @cell = "ALL"))

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.