Counting values within multi selection dropdown column

I used a multi selection dropdown column to select each company that sent in a bid for that project and I want to keep track of the total number of bids sent for each company. The formula I used is COUNTIF({Architect Selection}, "BSA") to count the number of times BSA appears in the column I referenced from another sheet. However, it only works if there is one value in the cell and not multiple. Please advice what formulas to use to count specific values in a multi selection dropdown column.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!