Countifs OR

Nick Allgauer

I'm trying to count how many match the first (Location) and second (Status) criteria, and then match one of the third (Position) criteria:

=COUNTIFS({Location}, "Wisconsin VAC", {Status}, "Offer in Progress", OR({Position} = "Applicator", {Position} = "Registered Nurse", {Position} = "EMT", {Position} = "PA/NP"))

Thoughts?

Paul Newcome

Try this...

=COUNTIFS({Location}, "Wisconsin VAC", {Status}, "Offer in Progress", {Position}, OR(@cell = "Applicator", @cell = "Registered Nurse", @cell = "EMT", @cell = "PA/NP"))

Paul Newcome

Try this...

=COUNTIFS({Location}, "Wisconsin VAC", {Status}, "Offer in Progress", {Position}, OR(@cell = "Applicator", @cell = "Registered Nurse", @cell = "EMT", @cell = "PA/NP"))

Nick Allgauer

Perfect! Thanks.

Paul Newcome

Happy to help. 👍️