COUNTIF with HAS or FIND

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?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!