COUNTIFS - Referencing a Status column in another sheet

Jodi Steele

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!

Jodi Steele

Thank you!

Jenn Hilber

Hi @Jodi Steele,

It looks like the @cell is out of place. Have you tried:

not "In Progress" =COUNTIFS({Assigned}, Trainer@row, {Status}, <>"In Progress")

"In Progress" =COUNTIFS({Assigned}, Trainer@row, {Status}, "In Progress")

Jodi Steele

Thank you!