Countif function for dropdown (multi select) column

kleinsb

I am trying to create a function/formula to count all of the times a dropdown selection is used in a dropdown (multi select) column but am having troubles. The goal is to create a summary table that includes each of the dropdown options but I am having trouble figuring out how to format the function/formula.

=COUNTIF([Type of Work Order Issue]:[Type of Work Order Issue], CONTAINS("No Work Order", [Type of Work Order Issue]:[Type of Work Order Issue])

^ This is the formula I am working with but it's saying 0 which is not accurate.

Any advice is greatly appreciated!

kleinsb

That works! Thank you MCorbin! I am going to have to do more reading into the @cell function, this is the first time I've seen it!

MCorbin

Try using @Cell

=COUNTIF([Type of Work Order Issue]:[Type of Work Order Issue], CONTAINS("No Work Order",@cell)

kleinsb

That works! Thank you MCorbin! I am going to have to do more reading into the @cell function, this is the first time I've seen it!