COUNTIFS with reference to another sheet with multiple criteria

Options

I'm looking for the correct syntax to count the number of lines from a reference sheet that meets criteria from two columns:

Count number of lines where Type (Column) = "Action Item" and Status (Column) <> "Closed"

This is the formula I used:

=COUNTIFS({RI-eProc Action Item, Issue & Risk Tracker Range 1},[Type:Type]="Action Item", [Status:Status]<>"Closed")

Unfortunately, I'm receiving #UNPARSEABLE.

Thank you in advance for you assistance!

Comments