View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carlos Paez Carlos Paez is offline
external usenet poster
 
Posts: 1
Default User defined function

I am searching for a User defined function that works in Hierarquical
structures.

Hierarquical structures contents elements at a level (father) that are
divided in different elements at the next level (sons). The Work Break
Down Structure used in Project management is one of them, usually each
element has a identifying code like this:



CODE MH

1

1.1

1.1.1 30

1.1.1.1 10

1.1.1.2 20

1.1.2

1.1.3

1.2

1.3

1.4





If an element has an assigned value (for example man hours MH), the "father"
has value of the summation of its "sons" (30=10+20). Calculation is made
this way up to the top of the structure.



Is it possible to develop a function to calculate the sum of the variable
(MH) at any level? (provided that values at the lowest level are known)