Sum Child Rows when "children" are a different column
I am sure this has been asked before, but I can't seem to figure out a solution that will work in my sheet. I am trying to sum the child rows of a specific column, but my formula isn't working. Can someone take a look at the screenshot and see if you can help?
I need to add the individual expenses (in the Expense Total column) for each item under "Lastname, Firstname" (Description column). Currently my formula in the Expense Total parent row is =sum(children[Expense Total]@row), but this isn't working, I'm guessing because the children are technically in the 'description' column. Is there a way I can write the formula to sum the individual expenses for the children of "Lastname, Firstname" in the Expense Total column?
Thank you in advance!
Help Article Resources
Check out the Formula Handbook template!