COUNTIFS Multiple Criteria and Checkbox - #INCORRECT ARGUMENT SET
Options
Amanda Chu
✭✭
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
-
Hello,
It looks as though you have three ranges, but only two criterion defined in your formula.
=COUNTIFS({Client Name}, "Client_1", {Client Experience Manager}, "Joe Smith", {Terminated Checkbox}, 0)
-
Matt_01 is correct. You need to establish the criteria for the Client Name range.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!