COUNTIFS and CONTAINS in Cell-Reference Formula

aschneiderheinze1025

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.

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

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