Parent rolling up data in Children rows

Maz Uddin

Green line is the parent row

everything inbetween is children rows

Column 30 is counting rows from N/A column that are not ticked, which are the rows im looking for. so 6 rows are active rows which are being used.

out of the 6 rows, 4 rows have been ticked in appoinment concluded column

i want to roll up the count of 4 in the parent column in column 31

is this possible?

would appreciate help from everyone or anyone. Thank you in advance!

@Paul Newcome @jmyzk_cloudsmart_jp I have tagged guys if you can help please?

Matt Lynn-PCG

@Maz Uddin

Use this in your parent row:

=COUNTIFS(CHILDREN([N/A]@row), 1, CHILDREN(), NOT(ISBLANK(@cell )))

Matt Lynn-PCG

@Maz Uddin

Use this in your parent row:

=COUNTIFS(CHILDREN([N/A]@row), 1, CHILDREN(), NOT(ISBLANK(@cell )))

Maz Uddin

@Matt Lynn-PCG it worked! thank you very much!