Countifs returning no match

Options

I cannot for the life of me figure out why this isn't working...it 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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!