# COUNTIFS with OR

Options

Hello,

I have spent hours trying to figure out what I am doing wrong, but I cannot seem to figure out what would get this formula to work. I am trying to count if my Simulation column says Phillips, the complete checkbox is checked and Type is Pilot OR Simulation. The formula works fine up until I add in the Type being Pilot or Simulation. I thought maybe it is because the logical expression is incomplete?

=COUNTIFS(Simulation:Simulation, "Phillips", Complete:Complete, 1, OR(Type:Type, "Pilot", Type:Type, "Simulation"))

Tags:

• ✭✭✭✭✭✭
Options

Greetings Erin,

Here is the formula I think should resolve your problem:

=COUNTIFS(Simulation:Simulation, "Phillips", Complete:Complete, "1", Type:Type, OR(@cell = "Pilot", @cell = "Simulation"))

For the OR statement, you can reference the @cell for your comparisons.

Please let me know how this works.

Frank Smith, PMP

Assistant Director | IT Special Projects Mgr.

Oregon Parks & Recreation Department

If my response helps, please mark it as an accepted answer. 😎

• Options

I think it might be because you need parentheses around your first scenario...

=COUNTIFS((Simulation:Simulation, "Phillips", Complete:Complete, 1), OR(Type:Type, "Pilot", Type:Type, "Simulation"))

• ✭✭✭✭✭✭
Options

Greetings Erin,

Here is the formula I think should resolve your problem:

=COUNTIFS(Simulation:Simulation, "Phillips", Complete:Complete, "1", Type:Type, OR(@cell = "Pilot", @cell = "Simulation"))

For the OR statement, you can reference the @cell for your comparisons.

Please let me know how this works.

Frank Smith, PMP

Assistant Director | IT Special Projects Mgr.

Oregon Parks & Recreation Department

If my response helps, please mark it as an accepted answer. 😎

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!