Indent Level Summations for Quotation Sheets

Mathieu Kotnjek

Hello,

I am trying to find a suitable formula so that my Total Hours indent level 0 row can sum all underlying indent level 1 Total Hours column values and stop the sum at the next indent level 0 row.

Is this possible?

Matt Johnson

Hi @Mathieu Kotnjek

I usually do =SUM(CHILDREN()) in the Total Hours parent row and then lock that row. It's not a perfect solution because you have to set it up each time you add a new parent row but its simple and easy to understand for others to use on their sheets. There's probably other ways too.

I hope that helps.