How do I write a formula for finding the sum of all the rows below the parent?
I am wanting to take all the information that will populate in rows 2 and down to add together under Part Cost to create a sum. How can I do this?
Answers

@Rebecca Dudley You can put a formula like this in a parent row to gather data from children rows.
=sum(children())

I do have that currently in there, but for sheets that have information, it is not populating a sum for them. Do I need to create a new parent row?

I would probably need to see a screenshot..
Is the sum data in the same column that you have the formula in the parent row?
If it's in a different column, you may need to modify for example:
=sum(children(part@row))

The Part Cost, Labor Cost, and Total Cost all have the =sum(children()) in that blue row. I had previously copied this sheet from an original. Could that be a problem as well?

I figured out that I had not indented the children rows. All fixed!

@Rebecca Dudley okay glad you found that! I was going to ask you that question next 😂. Let me know if you need anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!