Is there a way to count the number of parent rows with more than a certain number of children?
I have a column of P/N's in development. Most are individual projects, but some are for customer that have multiple P/N's which are indented under a parent row. I am wanting to know if there is a way to count how many projects I have that contain more than 25 P/N's or "children".
Best Answer

Max,
I think you could do this! You could add a new column, and use this as the column formula, assuming your column with the parents/children is called "Project Name":
=count(children([project name]@row))
Let's say I call the column I just created "Count" (for lack of a better idea).
Then you could put this formula somewhere  maybe in a Sheet Summary:
=countif(count:count, >25)
Hope this helps!
Best,
Heather
Answers

Hello @Max Corbin
Yes. The easiest way is with a helper column. I will show you two ways, depending upon what you ultimately wish to do with the data
With a checkbox column you can easily flag the parents with children >25. If you later wanted to know how many were >30, you would have to change the formula and/or add another helper column.
=IF(COUNT(CHILDREN([your primary row@row))>25, 1)
If you were using this in a report and you wanted to be able to easily adjust the number, use a Text/Number column and count. Since I don't like to see a bunch of zeros in my sheets, I first checked to see if the row was a parent row.
=IF(COUNT(CHILDREN([your primary row]@row)) > 0, COUNT(CHILDREN([your primary row]@row)))
Be sure to add your primary column name to the formula.
Kelly

Max,
I think you could do this! You could add a new column, and use this as the column formula, assuming your column with the parents/children is called "Project Name":
=count(children([project name]@row))
Let's say I call the column I just created "Count" (for lack of a better idea).
Then you could put this formula somewhere  maybe in a Sheet Summary:
=countif(count:count, >25)
Hope this helps!
Best,
Heather
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!