Countifs returning no match

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!

Find more posts tagged with

Accepted answers

All comments

Amber Eakin

Good morning, @Tanya Boehmke ! Can you share a screenshot? I don't see any immediate red flags, so a visual aid might help. Thank you!

Tanya Boehmke

Not sure what you would need to see...?

Tanya Boehmke

Ok idea....the Preferred Agreement column if filled in by an Index/Match formula off of another sheet. Would that cause issues? I tried the formula just on if the column was checked and that didn't work either.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.