Formula to display count of multiple items in cell

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")

Best Answer

Answers

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

  • Paul Newcome
    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?

    thinkspi.com

  • 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
    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.

    thinkspi.com

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

  • Paul Newcome
    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.

    thinkspi.com