Parent rolling up data in Children rows

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?
Best Answer
-
Use this in your parent row:
=COUNTIFS(CHILDREN([N/A]@row), 1, CHILDREN(), NOT(ISBLANK(@cell )))
Matt Lynn
Answers
-
Use this in your parent row:
=COUNTIFS(CHILDREN([N/A]@row), 1, CHILDREN(), NOT(ISBLANK(@cell )))
Matt Lynn
-
@Matt Lynn-PCG it worked! thank you very much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!