COUNTIFS Multiple Criteria and Checkbox - #INCORRECT ARGUMENT SET

Amanda Chu
Amanda Chu ✭✭
edited 12/09/19 in Formulas and Functions

I am having #INCORRECT ARGUMENT SET error message with this COUNTIFS. Please help. 

I am trying to Count Client Name column if both criteria are met. 

1) Client Experience Manager = "value"

2) Terminated checkbox not CHECKED

 

=COUNTIFS({Client Name}, {Client Experience Manager}, "Joe Smith", {Terminated Checkbox}, 0)

 

Any help would be appreciated.

Thank you!

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!