COUNTIFS - Referencing a Status column in another sheet
I am trying to create a metrics grid that will count tasks assigned to individuals based on the documented status and keep getting either an #Unparseable or an #Incorrect Argument error. In the screenshot below, I've captured the working formula for the Total Assigned column and two variations of what I've tried to do in the In Progress column. I'd be grateful for any suggestions you could share!
Help Article Resources
Check out the Formula Handbook template!