COUNTIF with HAS or FIND

Jennifer Lenander · 07/09/21

I am trying to count which companies provide what paid holidays. Below is how I'm trying to count where "[Column2]15" is "New Years Day.

The range I'm trying to pull from:

I tried "HAS" and "FIND" and I'm not getting the right results. Any thoughts on what I'm doing wrong?

Leibel S · 07/12/21

Use CONTAINS function. The HAS function only works with multi select dropdowns...

Mark Cronk · 07/10/21

Try:

=countif({paid holiday}, HAS(@cell, [column2]15)

Mark

Jennifer Lenander · 07/12/21

Thanks, Mark. But that didn't work.

Leibel S · 07/12/21

Use CONTAINS function. The HAS function only works with multi select dropdowns...

Jennifer Lenander · 07/12/21

Thanks so much @Leibel S ! I knew there was another function to try and couldn't think of it. This worked!

Mark Cronk · 07/13/21

Mark

Best Answer