Issue with COUNTIFS formula with OR condition

Anne-Solene Monrouzeau

Hi,

I have an invalid operation error with the formula below. I want to count all active projects for environment = Reed Services, Reed Saas, V4. Any idea what's going on?

=COUNTIFS([Project Status]:[Project Status], "Active", Environment:Environment, "Reed Services", OR(@cell = "Reed SaaS", @cell = "V4"))

Thanks!

Anne-Solene

Paul Newcome

You would need to include the "Reed Services" in the OR function.

=COUNTIFS([Project Status]:[Project Status], "Active", Environment:Environment, OR(@cell = "Reed Services", @cell = "Reed SaaS", @cell = "V4"))

Paul Newcome

You would need to include the "Reed Services" in the OR function.

=COUNTIFS([Project Status]:[Project Status], "Active", Environment:Environment, OR(@cell = "Reed Services", @cell = "Reed SaaS", @cell = "V4"))

Anne-Solene Monrouzeau

That works! Thanks

Paul Newcome

Happy to help. 👍️