Count occurrences in a drop down

TMB

Can anyone tell me why this statement isn't working? Thank you!

Dakota Haeffner

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!

Dakota Haeffner

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!

TMB

Thank you! That second one worked!