=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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!