COUNTIFS with criteria & exclusion

Trish Kernen

Hello, I am looking for help with a formula to determine how many files are assigned to a specific person that are not closed. The column names are listed below:

1. [File Manager]
2. [File Status]

I have a separate sheet for metrics that I am hoping to pull this data into and I have tried this fornula below:

Note - the Label@row contains the file managers name in a separate column)

=COUNTIF({File Tracker 1}, Label@row, (NOT(CONTAINS("File Closed", @{File Tracker 2}))

I get the error message #UNPARSEABLE

Any help is greatly appreciated.

Leibel S

@Trish Kernen

Seems like you need the below:

=COUNTIFS({File Tracker 1}, Label@row,{File Tracker 2},NOT(CONTAINS("File Closed",@cell)))