COUNTIF with CONTAINS and multiple references

Hello, I have the following formula, that works in my database:

=COUNTIF({Pain points}, (CONTAINS("CSMT", @cell )))

I need, however, to create another formula that contains this, but also adds another condition.

I have tried these but it wont work, any help please?

=COUNTIF({Pain points}, (CONTAINS("CSMT", @cell )), {Teams}, HAS(@cell , "Team 1")
=COUNTIF({Pain points}, (CONTAINS("CSMT", @cell )) AND {Teams}, (CONTAINS("Team 1", @cell )))

Thanks!

Find more posts tagged with

Accepted answers

All comments

nicksnav

=COUNTIFS({Pain Points}, CONTAINS("CSMT", @cell ), {Teams}, CONTAINS("Team 1", @cell ))

Would this formula work for you instead. It seems to find all rows containing "CSMT" and "Team 1". Let me know!

lfernndez

No, it says INVALID

jjg279

@lfernndez I think you could try it without the contains:

=COUNTIFS({Pain Points}, "CSMT", {Teams}, "Team 1") - countifs will only return something if all parameters are met in one row. Just make sure your ranges are the same length!

nicksnav

@Ifernndez, INVALID what? Is there more to the error message given? So, you are wanting to count the instances of rows that have both "CSMT" and "Team 1". And these columns are on the same sheet?

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.