Formula to display count of multiple items in cell

Alisia Gill · 02/20/20

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 · 02/20/20

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 · 02/20/20

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 · 02/20/20

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

Paul Newcome · 02/20/20

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 · 02/20/20

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 · 02/20/20

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 · 02/20/20

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

Paul Newcome · 02/20/20

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.

Formula to display count of multiple items in cell

Best Answer

Answers

Help Article Resources

Categories