Formula to count multiple selections in a column

Options

Example:

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?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!