Countif when multiple values

darrink

I have a form that allows users to multi select.

I have a metrics sheet that counts the number of times a selection appears, however, it's only working for those that only had a single value selected. Multi-select are NOT being counted.

Is there a way to get counts when there are multiple values in the same cell?

Here's the formula I'm using right now.

=COUNTIF({Request Tracker Range 4 - Request Type}, Category9)

Mark.poole

@TraisHorloff

The order of the function calls matter. In this cause you want.

=COUNTIF({Request Tracker Range 4 - Request Type}, OR(HAS(@cell, "Category9"), HAS(@cell, Category10")))

Mark.poole

@darrink

=COUNTIF({Request Tracker Range 4 - Request Type}, HAS(@cell,Category9))

darrink

Thanks @Mark.poole I will give it a shot!

TraisHorloff

https://community.smartsheet.com/discussion/comment/440968#Comment_440968

How would the formula look like if the cells I'm counting have multiple values. This one doesn't seem to be working as it always show 0. Thanks for your help.

=COUNTIF({Request Tracker Range 4 - Request Type},HAS(@cell,OR(@cell="Category9",@cell="Category10")))

TraisHorloff

To clarify, I want to count the items, which have "Category9" or "Category10". The cells have multiple values "Category1" to "Category10".

Mark.poole

@TraisHorloff

The order of the function calls matter. In this cause you want.

=COUNTIF({Request Tracker Range 4 - Request Type}, OR(HAS(@cell, "Category9"), HAS(@cell, Category10")))

TraisHorloff

@Mark.poole

That's it, thank you!