COUNTIFS PARENT cross reference

Misayely Abias

In my summary sheet, I need to cross reference the PARENT rows in my data sheet (status) to count the number of open non-conformities (with less than 100% complete). Basically, the counting in summary sheet needs to take into consideration two conditions in the status sheet:

1. Be a PARENT row, and
2. % complete <1

I have tried everything I can and I still cannot it to work

Ramzi K

@Misayely Abias

Add a "helper" column to your status sheet called IsParent (of type Checkbox) and then put a column formula in it:

=IF(COUNT(CHILDREN(Item@row)) > 0, true)

In your summary sheet use the formlua =COUNTIFS({Status SheetIsParentColumn}, true, {Status Sheet% CompleteColumn}, <1)

I hope this help.

Cheers,

Ramzi

Ramzi K

@Misayely Abias

Add a "helper" column to your status sheet called IsParent (of type Checkbox) and then put a column formula in it:

=IF(COUNT(CHILDREN(Item@row)) > 0, true)

In your summary sheet use the formlua =COUNTIFS({Status SheetIsParentColumn}, true, {Status Sheet% CompleteColumn}, <1)

I hope this help.

Cheers,

Ramzi

Misayely Abias

Ranzi, this is just perfect!

Thank you so much