Formula to display count of multiple items in cell

Alisia Gill

I'm trying to create a formula that will calculate when there are more than 1 item checked in a column to display accurately in my dashboard count.

Example:

My Strategic Initiative column has the ability to choose multiple SI's for 1 Project. The project has 2 or more SI's, my current formula is not calculating these to the dashboard. Here is my current formula:=COUNTIFS({MI2 Strategic Initiatives}, "1a - Integration of data elements for care coordination, quality management and financial performance")

Paul Newcome

Try using a CONTAINS function.

=COUNTIFS({MI2 Strategic Initiatives}, CONTAINS("1a - Integration of data elements for care coordination, quality management and financial performance", @cell))

Paul Newcome

Try using a CONTAINS function.

=COUNTIFS({MI2 Strategic Initiatives}, CONTAINS("1a - Integration of data elements for care coordination, quality management and financial performance", @cell))

Alisia Gill

The user could choose up to 20 Strategic Initiatives in this column, how to do add all 20 choices to this formula?

Paul Newcome

I'm not sure I follow what you are asking for. Are you trying to count how many options are selected, or are you trying to count how many time a particular option is selected even if there are multiple selections made within a cell?

Alisia Gill

I apologize. I'm trying to count how many of each Strategic Initiative is selected for a particular team if there are multiple selections made within a cell?

Example: IT Business team has a project named "X" on my master project list with 2 or more SI's chosen in the cell out of 20. I need the total count per SI for each IT Team. See the screenshot of my master roll up below that is linked to my Master project list.

Paul Newcome

So you want to count how many times "1a - Integration of data elements for care coordination, quality management and financial performance" shows up in the multi-select field in the same row as "Business" in another field? If so, the formula I previously provided should work.

Alisia Gill

The formula you provided is working, I greatly appreciate it.

Paul Newcome

Excellent! Happy to help! 👍️

Please don't forget to mark the most appropriate response(s) as "helpful". That way others searching for a similar solution can know that one may be found here.