Count Ifs AND

lesmickin

Im trying to do a count that captures criteria where both the Status is makred as closed and the TEA Jurisdiction is marked as yes.

=COUNTIF(AND([Status]:[Status], "Closed", [TEA Jurisdiction]:[TEA Jurisdiction], "yes"))

I keep getting the incorrect argument set error.

Thanks for any help

Paul Newcome

You don't need the AND. Just a COUNTIFS (with the S on the end).

=COUNTIFS([Status]:[Status], "Closed", [TEA Jurisdiction]:[TEA Jurisdiction], "yes")