Referencing Another Sheet: Count

Tony Barthelemy

Good day all:

 

I am counting number Rows in another sheet. However, I do not want to include the Parent or Grand Parent Row in that count, just the children and grandchildren. thoughts on how I would structure this formula? Thanks

My formula =COUNTIFS({Mi-Config 7.2 WBS Range 1}, 1)

Mike Wilday

Do you have a column or some identifier that indicates that a row is a Parent or Grandparent? Because the children function will recognize parents as children of the grandparent. 

Tony Barthelemy

The sheet is in a WBS structure which contain parent child and grandparent grandchild relationship. If that  is what you are asking?