Need help with COUNTIFS, CONTAINS, AND

I am stumped and cannot find an example. I want to count the cell in range 1 contains the word "flight" and the cell in range 4 on the same row contains the word "enterprise"

This gives #incorrect argument:

=COUNTIF({2022 Project List Range 1}, CONTAINS("flight", @cell), AND({2022 Project List Range 4}, CONTAINS("enterprise", @cell)))

This gives #invalid data type:

=COUNTIFS({2022 Project List Range 1}, "Pushed to 2022", AND({2022 Project List Range 4}, CONTAINS("enterprise")))

Thanks!

Find more posts tagged with

Accepted answers

Paul Newcome

Your first one is going to be the closest. You just don't need the AND function because it is implied in a COUNTIFS.

=COUNTIF({2022 Project List Range 1}, CONTAINS("flight", @cell), {2022 Project List Range 4}, CONTAINS("enterprise", @cell))

All comments

Paul Newcome

Your first one is going to be the closest. You just don't need the AND function because it is implied in a COUNTIFS.

=COUNTIF({2022 Project List Range 1}, CONTAINS("flight", @cell), {2022 Project List Range 4}, CONTAINS("enterprise", @cell))

Becky M.

Thank you @Paul Newcome that worked perfectly beginning with =COUNTIFS

Paul Newcome

Happy to help. 👍️

And that's what I get for copy/pasting and not proofing before posting. Haha. Glad you caught that.

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.