Counting Instances in Cell with Multiple Drop Down Select

Options

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!

Donna


Best Answer

Answers

  • Donna T
    Donna T ✭✭
    Options

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