COUNTIFS with OR

erin.smith

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

Frank S.

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.

StefanieM

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

Frank S.

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.