Count multiple drop downs all containing a specific text within the same cell
I have a multiple drop-down column where I am referencing various Row IDs. They have an autonumber followed by a prefix.
As an example, a row can have a multiple choice filled with the following
001A ; 002A ; 005A ; 001B ; 003C ; 006C
I want to be able to count how many of the options are selected that have a specific prefix. Say I want to know that there are three choices with a prefix A (001A, 002A, and 005A in the example above).
How can I count that with a formula?
Thanks anybody outhere! :-)
Help Article Resources
Check out the Formula Handbook template!