title: SHEETS: How do you sum children recursively into a parent row?
body: <p>I have a simple google sheet where each row represents a node in a tree that holds a reference to its parent and some descriptor values about it. I would like to have a column that sums the child nodes beneath the current one.</p>
  <p>e.g:</p>
  <pre><code>Node ID, Parent Node ID, Minimum Value, Self Value, Total Value
  1, 0, 30, 10, 90
  2, 1, 10, 20, 40
  3, 1, 10, 20, 40
  4, 2, 1, 10, 10
  5, 3, 1, 10, 10
  6, 3, 1, 10, 10
  7, 2, 1, 10, 10
  </code></pre>
  <p>Where <code>Self Value</code> is statically defined, and <code>Total Value</code> represents <code>Self Value + SUM(CHILDREN.Total Value)</code>. Do I need to re-organize the sheet to accomplish this or am I missing the proper way to recursively sum-up the child rows?</p>