Summary formula to count the number of rows in a sheet that have no children?!

sean59916

Hi,

I've been racking my brain trying to get this formula to work!

I can create a helper column in the sheet and display the number of children each row has, then simply use a CountIf function - if Children=0, but, I thought i could use a COUNTIF with @cell to not require the helper column?

I have tried the following

=COUNTIF({Ref Col}, COUNT(CHILDREN(@cell))=0)

Thank you

Paul Newcome

Hierarchy functions unfortunately cannot use the @cell reference. You will need to use the helper column for that.

sean59916

Thanks for the response Paul. Much appreciated.

Paul Newcome

Happy to help! 👍️