COUNTIFS incorrectly counting number of times a contact appears in Assigned To column
I am trying to track the number of tasks each employee is assigned to. In my Assigned To column, some cells have one contact assigned to a task and others multiple contacts. I am currently using the following function:
=COUNTIFS([Assigned To]:[Assigned To], "John Smith", [Status]:[Status], <>"Complete")
The function returns a number, but it is incorrect. For example, I know one of my contacts has 7 tasks assigned to them, but the function is returning the number 2. I have also tried using COUNTIFS with HAS but got the same results:
=COUNTIFS([Assigned To]:[Assigned To], HAS([Assigned To]:[Assigned To], "John Smith"), [Status]:[Status], <>"Complete")
It seems that the function is simply not finding all of the results. Any feedback is greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!