Tree sumation in Excel (with or, if possible, without VBA)

[sandros]

Hello everybody,

I have to model branched water supply network showed in picture attached here

https://goo.gl/jJFhMx.
Node numbers are written in brackets, while pipe numbers are written in red and rectangled. Water demand is defined in nodes and marked with an arrow.

So, input data are pipe number, upstream node number, downstream node number and demand in downstream node as in attached .xls file https://goo.gl/EqA6kz.

Is it possible to get flows in pipes by summation all demands in nodes "downstream" of the specific pipe?

I hope I was clear and thanks in advance!
Sandro

 

[sandros]

Thank you shg, it works perfectly!

Sandro

 

[shg]

You're welcome.