CountIFS for Parent Row Only

mmurray109161

Hello - 

I am displaying some information regarding things that are approved, in queue or denied. But I am needing to only count parent rows and not the children for them.  So the data collected are just for the overall brand and not sub-brands. Is there a way for me to make this happen?

Thank you - 

Mmurray 

Frank Falco

You will need to add some columns that you can hide to calculate which rows are a parent.

If you only want to absolute top-level parent, you can use

Level: =COUNT(ANCESTORS()+ 1

When Level = 1 it is the top-level, 2, 3, and so on for sub levels

If you want to know about sub parents

Subs: =COUNT(CHILDREN()) 

any row that has Subs>0 is also a parent

Using these two you can get a good knowledge of where you are in the hierarchy.

 

When you have this in place you can then use the level or subs values in your COUNTIFS formulas.