Sum of expenses of child rows in a formula row
I have a sheet wherein a column contains all the expenses that is basically generated from the sum of other cells in the same row.
This row is indented and I wanted to know if I could have the total of this in the parent of this row. Like the way it could be done in a pivot table.
The formula in the column is applied as a column formula and I'm unable to put a unique formula for the other parent rows. Is there any way I could do this?
Help Article Resources
Check out the Formula Handbook template!