COUNTIF Formula for Multiple variables within a column


I have a sheet column that captures dropdown selections made on a Form. Users are given 4 variables to choose from. They can choose one selection or multiple selections.

I have created the following formula to capture the count of each individual selection(example):

=COUNTIF([Segment Impacted]:[Segment Impacted], "Virtual")

That formula provides me with the exact amount of times the Virtual variable was chosen.

I am looking for a formula that captures the count when ALL 4 of the available dropdown variables are selected. (i.e. Virtual1, Virtual2, Virtual3, Virtual4).

Any advice?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!