COUNTIF Formula for Multiple variables within a column

Hello,

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?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!