COUNT IF TWO CONDITIONS ARE MET

Sylvia Elizabeth

Hi!

I have this formula to identify if all my status are "Completo" then turn the cell "Completo", but if a children status is "Sin iniciar" then the status must stay "Sin terminar". But I want to include another status in my column "Condicionado", so I want that if all my status are "Completo" or "Conditionado" change the status to "Complete" too.

=IF(AND(COUNTIF(CHILDREN(); "Completo") > 0; COUNTIF(CHILDREN(); "Completo") = COUNT(CHILDREN())); "Completo"; "Sin terminar")

Can somebody help me please?

Thank you

Mark Cronk

One more try:

=IF(COUNTIF(CHILDREN(); OR(@cell="Completo", @cell="Conditionado")) = COUNT(CHILDREN()); "Completo"; "Sin terminar")

Mark

Kelly Moore

Hey @Sylvia Elizabeth

If I understand correctly, this formula is working now for you but you want to add the additional condition to it? I wondered if the first IF is to determine if the row is a PARENT row? If yes then consider counting any child, not just if any of the children are complete.

I believe this is what you wanted?

=IF(COUNTIF(CHILDREN(); "Completo") > 0; IF(OR(COUNTIF(CHILDREN(); "Completo"; COUNTIF(CHILDREN(); "Conditionado"))) = COUNT(CHILDREN()); "Completo"; "Sin terminar"))

If the first IF was just to look for Parent rows then consider this formula instead

=IF(COUNT(CHILDREN()) > 0; IF(OR(COUNTIF(CHILDREN(); "Completo"; COUNTIF(CHILDREN(); "Conditionado"))) = COUNT(CHILDREN()); "Completo"; "Sin terminar"))

cheers,

Mark Cronk

Hi @Sylvia Elizabeth ,

Try:

=IF(AND(COUNTIF(CHILDREN(); "Completo") > 0; COUNTIF(CHILDREN(); OR(@cell="Completo", @cell="Conditionado") = COUNT(CHILDREN())); "Completo"; "Sin terminar")

Work?

Mark

Sylvia Elizabeth

Hi!

Thank you @Mark Cronk and @KDM for your quick response!. However both suggestions drop me incorrect argument.

For example in that case ( the image I show below) the parent row is the one I want to change the status to Completo because all my children are "Completo" and one of them is "Condicionado". If one of my status is "Sin iniciar" the parent status must say "Sin terminar"

Hope with this example you can help me with the problem.

Thankyou!

Mark Cronk

One more try:

=IF(COUNTIF(CHILDREN(); OR(@cell="Completo", @cell="Conditionado")) = COUNT(CHILDREN()); "Completo"; "Sin terminar")

Mark