COUNTIFS and CONTAINS in Cell-Reference Formula

In Sheet 1, I have a drop down column called [Status] and a contact column called [Program Developer].

In Sheet 2, I want to write a formula that counts the number of times (or rows) in which Email@row (in Sheet 2) appears in [Program Developer] in Sheet 1, when the [Status] of that row contains "Stage 1".

If I'm just counting instances of Email@row, no problem. I am not sure how to include the CONTAINS part for the Status column.

Find more posts tagged with

Accepted answers

Kelly Moore

Hey @aschneiderheinze1025

Clarification question- Is your dropdown [Status] column a multi-select column? Or are there multiple "Stage 1 …" choices and you want to count all of them? If no to both, then you don't need to use CONTAINS

=COUNTIFS({Sheet 1 Program Developer}, Email@row, {Sheet 1 Status}, "Stage 1")

however, in case you do have a legit need for CONTAINS then

=COUNTIFS({Sheet 1 Program Developer}, Email@row, {Sheet 1 Status}, CONTAINS("Stage 1", @cell))

Kelly

All comments

Kelly Moore

Hey @aschneiderheinze1025

=COUNTIFS({Sheet 1 Program Developer}, Email@row, {Sheet 1 Status}, "Stage 1")

however, in case you do have a legit need for CONTAINS then

=COUNTIFS({Sheet 1 Program Developer}, Email@row, {Sheet 1 Status}, CONTAINS("Stage 1", @cell))

Kelly

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.