Trying to get OR to work with Countifs

Wade Herrin

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

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

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

👍