Trying to get OR to work with Countifs

First part of Countifs works, cannot get OR to work.

Want to count everything that is before today that is Current State ="In Queue" or "In Process". Current error I get is invalid operation. Have tried multiple iterations without luck. What am I missing? Thanks!

=COUNTIFS({CNC, CMM, and BL Request Sheet Need by date}, <TODAY(0), OR({CNC, CMM, and BL Request Sheet Current State} = "In Queue", {CNC, CMM, and BL Request Sheet Current State} = "In Process"))

Find more posts tagged with

Accepted answers

Carson Penticuff

I think this will do it:

=COUNTIFS({CNC, CMM, and BL Request Sheet Need by date}, < TODAY(0), {CNC, CMM, and BL Request Sheet Current State}, OR(@cell = "In Queue", @cell = "In Process"))

Wade Herrin

Nailed it, thank you!

All comments

Carson Penticuff

I think this will do it:

=COUNTIFS({CNC, CMM, and BL Request Sheet Need by date}, < TODAY(0), {CNC, CMM, and BL Request Sheet Current State}, OR(@cell = "In Queue", @cell = "In Process"))

Wade Herrin

Nailed it, thank you!

Carson Penticuff

👍

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.