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)

User defined function
 

Carlos,

The Pivot Table will give you group totals. It won't put them into your
existing structure.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Carlos Paez" wrote in message
...
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)