Counting Check Boxes

I am trying to count the number of records that meet specific criteria and have a checkbox checked.

=COUNTIFS({Evaluation}, "1", {Resources}, CONTAINS("Scenario 2", @cell))

{Evaluation} is a column type of check box

{Resources} is a column type of dropdown

When I separate the two ranges and criteria into separate calculations they work as expected. When I try to use the COUNTIFS function I get the error message ##Incorrect argument set

Find more posts tagged with

Countif

Accepted answers

All comments

Leibel S

@Jeff_ARC

Your formula looks good here. Check the data for any errors

Jeff_ARC

I don't think there are any errors. When I split it into two countifs statements they work fine. I am also seeing a similar occurrence in another sheet using countif.

Nick Korna

I've been able to duplicate this - check your ranges. If one is the column and the other is just a selection of rows, you will get the #INCORRECT ARGUEMENT SET error.

Jeff_ARC

Thank you that was the issue. The {evaluation} value references a single column of data. My {Resources} value referenced more than one column. The COUNTIF function was unable to evaluate the because of that. I was able to correct it by creating one value for each column of data.

Thanks for you help!

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.