Using countif to select an option from a column

topazfae

I have multiple selections in a column and when I tried to use countifs, it will not pick up the label that is combinated with other options.

For example, in Column B, I have following look up values - Role 1, Role 2, Role 3, etc, but some rows have two or more roles - so in one row, it will say role 1, role 3. In another grid, I would countif from that column B = =countifs ({Letter}, TRUE, {Role}, "Role 3"), it will not pick the row with Role 1, Role 3.

How do I make sure I also pick up the row with Role 3 with other options

Nic Larsen

You can use something like this, just fix the column names to match yours:

=COUNTIF([Column B]:[Column B], FIND("Role 3", @cell) >= 1)

Nic Larsen

You can use something like this, just fix the column names to match yours:

=COUNTIF([Column B]:[Column B], FIND("Role 3", @cell) >= 1)

topazfae

@Nic Larsen It worked - thank you!