Count occurrences in a drop down
Can anyone tell me why this statement isn't working? Thank you!
Best Answer
-
I think you are trying to count the amount of times Monday is in the Days on Campus column. If that's the case, Try this:
=COUNTIF([Days on campus]@row, CONTAINS("Mon"))
I see a lot of people use HAS vs CONTAINS but I just have better luck with CONTAINS. I'm sure someone smarter than me could explain why lol.
If might need the field to search within inside the CONAINS Statement so if that doesn't work try this:
=COUNTIF([Days on campus]@row, CONTAINS("Mon", @cell))
Hope this helps!
Answers
-
I think you are trying to count the amount of times Monday is in the Days on Campus column. If that's the case, Try this:
=COUNTIF([Days on campus]@row, CONTAINS("Mon"))
I see a lot of people use HAS vs CONTAINS but I just have better luck with CONTAINS. I'm sure someone smarter than me could explain why lol.
If might need the field to search within inside the CONAINS Statement so if that doesn't work try this:
=COUNTIF([Days on campus]@row, CONTAINS("Mon", @cell))
Hope this helps!
-
Thank you! That second one worked!
Help Article Resources
Categories
Check out the Formula Handbook template!