I am trying to SUM the indented children rows in another cell that isn't the parent. Is this possible?
Yes! The formula would look like =SUM(CHILDREN([Insert name of column]))