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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!