COUNTIF for mutiple dropdowns in a cell

MT Thompkins

I am struggling with the proper formula. I have always struggled with the formulas here and Excel.

I have multiple drop downs in a cell, and I need to be able to show, how many times each of these choices were checked.

Using this formula

=COUNTIF([What educational topics were discussed]:[What educational topics were discussed], "Assistance with ADLs")

With each choice having it's own formula, if I only check a single item, I get a count, if I select multiple items I get "0".

Any help is GREATLY appreciated.

Mark

Adam Murphy

Try something like this: =COUNTIF([What educational topics were discussed]:[What educational topics were discussed], CONTAINS("Assistance with ADLs", @cell))

MT Thompkins

Thank you. That worked. For my education, why did it work?

Thanks again for the help

Mark

Adam Murphy

Try something like this: =COUNTIF([What educational topics were discussed]:[What educational topics were discussed], CONTAINS("Assistance with ADLs", @cell))

MT Thompkins

Thank you. That worked. For my education, why did it work?

Thanks again for the help

Mark

Adam Murphy

In your formula you were looking for an exact match of what you have in quotes, so it would only match if that was the only thing selected in the cell. By using the CONTAINS function instead it is searching for the quoted text anywhere within the cell, so regardless of what else is also selected, it will find a match. Make sense?

MT Thompkins

Thank you very much.