COUNTIFS on multiple columns looking for multiple conditions.
Im trying to count how many rows fit a specific criteria.
Here is my example table:
In this example I want to count how many rows are assigned to "In House" with a Status of "In" and Difficulty of "A".
This is my formula:
=COUNTIFS([Assigned To]:[Assigned To], "In House", [Status]:[Status], “In”,[Difficulty]:[Difficulty], “A” )
When I do that I get #UNPARSEABLE
Any help would be much appreciated!
Help Article Resources
Check out the Formula Handbook template!