Count if Question

NicoleB

I have a formula I am trying to figure out -

It is a parent/child formula

needs to be

1. one condition met in one column
2. one of 2 possible conditions met in another column

Keep getting error

Here is my formula for now -

=countifs(children([Issue Type]@row, "defect", children(OR(Status@row, "New", "In Progress"))))

Paul Newcome

Try somethign more like this:

=COUNTIFS(CHILDREN([Issue Type]@row), @cell = "Defect", CHILDREN(Status@row), OR(@cell = "New", @cell = "In Progress"))

Paul Newcome

Try somethign more like this:

=COUNTIFS(CHILDREN([Issue Type]@row), @cell = "Defect", CHILDREN(Status@row), OR(@cell = "New", @cell = "In Progress"))

NicoleB

Thanks @Paul Newcome ! worked like a charm

Paul Newcome

Happy to help. 👍️