How do I write a formula for finding the sum of all the rows below the parent?

Rebecca Dudley

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?

Samuel Mueller

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

=sum(children())

Rebecca Dudley

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?

Samuel Mueller

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))

Rebecca Dudley

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?

Rebecca Dudley

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

Samuel Mueller

@Rebecca Dudley okay glad you found that! I was going to ask you that question next 😂. Let me know if you need anything else.