COUNTIFS with an OR statement

Ireland Adgate

 =COUNTIFS([Phase]:[Phase], OR(2", "3", "4"), [Project Status]:[Project Status], "green")

 

When I input this formula I am getting a message back reading "#UNPARSEABLE". The part that I am struggling with is the OR statement. Is an OR statement possible within Countifs?

Paul Newcome

It is possible, but you need to use @cell references to make the criteria a logical statement.

 

=COUNTIFS([Phase]:[Phase], OR(@cell = "2", @cell = "3", @cell = "4"), [Project Status]:[Project Status], "green")