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
Answers
-
You don't need the AND. Just a COUNTIFS (with the S on the end).
=COUNTIFS([Status]:[Status], "Closed", [TEA Jurisdiction]:[TEA Jurisdiction], "yes")