Formula to count multiple selections in a column



Column A (called Retake Exam) has 3 dropdown selections. A user can select one, or all three:

  1. Yes
  2. No
  3. Maybe

I am trying to write a formula that will count entries where all three items were selected.

(Yes, No & Maybe)

When I try to use a CountIFS formula:

=COUNTIFS([Retake Exam]:[Retake Exam], "Yes and No and Maybe"), it returns with a total of zero even though there are several entries where all three options have been selected.

What is wrong with my formula?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!