COUNTIFS Multiple Criteria and Checkbox - #INCORRECT ARGUMENT SET

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!

Matt_01

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)

 

Paul Newcome

Matt_01 is correct. You need to establish the criteria for the Client Name range.