Countifs returning no match


I cannot for the life of me figure out why this isn't comes back with no match when there are 60. Spelling is right.

=COUNTIFS(Director:Director, "Nolan Schmidt", [Preferred Agreement]:[Preferred Agreement], 1)

The second range is a checkbox. Help please!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!