Formula to count multiple selections in a column

HarryS

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?

DKazatsky2

Hi @HarryS ,

The COUNTM() function will return the number of items selected in a muti-select field. Try this.

=COUNTIF([Retake Exam]:[Retake Exam], COUNTM(@cell) = 3)

Hope that helps.

Dave