How to count grandchildren rows?

Vlad Koliada

Hi there! Can't count grandchildren rows. I did use COUNT (CHILDREN) in children rows and SUM(CHILDREN) in parent one. Everything I got, was 0 in parent row. Please see screenshot attached. Can you help me, please?

Paul Newcome

My suggestion would be to use hidden helper columns to output just the counts so that you have numerical values that can be summed. Then in the parent rows you can use the same formulas you currently have that add the text but replace the COUNTs with cell references over to the hidden helper column.