COUNTIFS + OR - Forumla Help

ErinM

You're all so amazingly helpful that I'm back. I think this is an easy fix for most, but I'm scratching my head.

I have a column named Status with multiple drop down options, of which only one can be used. I also have a column named PMO that is a checkmark.

I want to get a count of PMO flagged rows that fall within several statuses (planning, execution, monitoring). The formula below works for one status - how do I sneak in the OR to pick up each of those three?

=COUNTIFS(Status:Status, "Planning", PMO:PMO, 1)

Thanks!

Nick Korna

Hi @ErinM,

You can do this using OR and @cell in the formula:

=COUNTIFS(Status:Status, OR(@cell = "Planning", @cell = "Execution", @cell = "Monitoring"), PMO:PMO, 1)

Result:

Hope this helps; if you've any further questions then just ask! 😊

Kelly P.

@ErinM

You could use this formula:

=COUNTIFS(Status:Status, "Planning", PMO:PMO, 1) + COUNTIFS(Status:Status, "Execution", PMO:PMO, 1) + COUNTIFS(Status:Status, "Monitoring", PMO:PMO, 1)

Hope this helps!

Nick Korna

Hi @ErinM,

You can do this using OR and @cell in the formula:

=COUNTIFS(Status:Status, OR(@cell = "Planning", @cell = "Execution", @cell = "Monitoring"), PMO:PMO, 1)

Result:

Hope this helps; if you've any further questions then just ask! 😊