COUNTIFS with reference to another sheet with multiple criteria

George H @ Civic

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!

Paul Newcome

It's going to end up looking something like this:

 

=COUNTIFS({RI-eProc Action Item, Issue & Risk Tracker Range 1}, ="Action Item", {RI-eProc Action Item, Issue & Risk Tracker Range 2},<>"Closed")

 

For Range 1, only select they Type column. Range 2 will only be the Status column. This should work for you.