=COUNTIFS formula and referencing another sheet. Getting error message: #INCORRECT ARGUMENT SET

Good morning! I'm using =COUNTIFS formula and referencing another sheet. One of criteria is result of a checkbox column.

=COUNTIFS({ETSI Contract Tracking Range 2}, 1, {ETSI Contract Tracking Range 5}, "1 way NDA")

Range 2 is checkbox. I want to count those that are checked.

Range 5 is column that contains Type of Contract that I want to count. This part of formula was working prior to adding second condition with checkbox.

Thank you!

Find more posts tagged with

Accepted answers

All comments

Jennifer Sullivan

Commenting on my own question. Ha! It's working now!

Andrée Starå

Hi @Jennifer Sullivan

I hope you're well and safe!

Excellent! Glad you got it working.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.