Counting values within multi selection dropdown column

Brian Conroy

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.

Mike TV

@Brian Conroy

Try this:

=COUNTIF({Architect Selection}, CONTAINS("BSA", @cell))