Multi-part formula with multi select field using references issue
Hello-
I am trying to write a formula that includes sheet references, and two conditions. I need to count the number of students in each category and how many of those students chose a specific availability time from a multi-select drop-down menu. This is what I came up with but doesn't work.
=COUNTIFS({Student Type}, "University Student", AND(HAS({Student Availability}, "Monday AM")
Can someone please help?
Thank you!
Kimberly S. Slavsky, MPAcc, MS (She/Her)
Operations Principal Professional |Department of Psychiatry
University of Colorado Anschutz Medical Campus
CU Anschutz Staff Council Vice Chair
University of Colorado Staff Council Vice Chair
Best Answer
-
Hi Kimberly, try this.
=COUNTIFS({Student Type}, "University Student", {Student Availability}, HAS(@cell, "Monday AM"))
--Anson
Answers
-
Hi Kimberly, try this.
=COUNTIFS({Student Type}, "University Student", {Student Availability}, HAS(@cell, "Monday AM"))
--Anson
-
That worked. Thank you!!!
Kimberly S. Slavsky, MPAcc, MS (She/Her)
Operations Principal Professional |Department of Psychiatry
University of Colorado Anschutz Medical Campus
CU Anschutz Staff Council Vice Chair
University of Colorado Staff Council Vice Chair
Help Article Resources
Categories
Check out the Formula Handbook template!