CountIF for a multi-select drop-down
I'm using a column to track what each row requires as a next step in the project. In some cases a row will need both say "requirement A" and "requirement B", therefore I'm using a multi-select dropdown because it makes the most sense for me.
In the sheet summary tab, I want to be able to count how many rows need "requirement A" and how many rows require "requirement B" and so on for other requirements in the dropdown.
Right now I'm using a CountIF formula such as: =COUNTIF(Comments:Comments, "Requirement A") - where "comments" is the column with these requirements. However, this formula disregards any rows where more than one dropdown is selected.
I want to be able to count rows more than once: i.e. if it has both Requirement A and Requirement B selected, it would be counted both times when I make summary cells for how many rows need requirement A and how many rows need requirement B.
Is there any way to do this? I appreciate the help in advance!
Help Article Resources
Check out the Formula Handbook template!