Issue with COUNTIFS formula with OR condition

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

Find more posts tagged with

Formulas

Accepted answers

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"))

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.