Counting Instances in Cell with Multiple Drop Down Select


We have an internal communications plan. In one column we track the method of communication. Sometimes the same communication, represented as a row, goes out via multiple methods, and therefore multiple selections are made in the Delivery Method cell.

I am trying to create some metrics. When I try to countif where cell={method}, it seems to only count the first one. That is to say, based on the image below it will always count the "Email (one-off)", but then I can't get it to count the 2nd, 3rd, etc entries in the same cell with Email (one-off), even if defined in the formula.

I know how to workaround it, but was hoping to keep my spreadsheet simple (I didn't want to have a column for each method if I could avoid it).

Any suggestions?

Thank you!


Best Answer


  • Donna T
    Donna T ✭✭

    Thank you so much! I forget about those subcommands for formulas!