Counting Check Boxes

Jeff_ARC

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

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!