How to create a formula with multiple criteria with OR logic?

Janka

Hi Team,

I would like to create some formulas with multiple criteria where some should work with OR logic. Could you advice if this is possible and how should I proceed?

Example:

From the sample data below, I would like to calculate: How many tasks there is that are being worked on (Task Phase is "Started" or "In progress") and at the same time are assigned to either Jane or Natalie.

Thank you in advance for suggestions!

Nick Korna

Hi @Janka,

For your question:

=COUNTIFS(Assigned:Assigned, OR(@cell = "Jane", @cell = "Natalie"), [Task Phase]:[Task Phase], OR(@cell = "Started", @cell = "In Progress"))

Hope this helps, but if you've any problems/questions with it, just post!

Janka

@Nick Korna Thank you so much! This is super helpful!

Have a great day!