What Formula Would Handle This?

Brian Andrews

I want the top row to calculate everything below it. I was using the Sum Children formula, but once I made the indent below with "Flavored Kre Pre-Launch", it won't calculate anything below it (just only if I put something in that same row). So, is there a way to write the formula in the top cell to read all of the ones listed below? I know a simple SUM formula listing the row ranges would do it, but I want to be able to simply add new rows down below without having to update the top row formula each time. The SUM Children one does this, but not with anything indented below.

Thanks!

Brian Andrews

Eureka! Yes, thanks!

Andrée Starå

Hi Brian,

You’d use DESCENDANTS for that.

Did that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Brian Andrews

Eureka! Yes, thanks!

Andrée Starå

Excellent!

Happy to help!