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:
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
Check out the Formula Handbook template!