Countifs OR

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?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!