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!