This newsgroup is for Word. Your question clearly pertains to Excel, so I
suggest you post it in an Excel NG.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Ed" wrote in message
...
Hello, I have a budget and i have set a column on the side to assign a
hierarchy (here shown in [] ) , which also gives a conditional formatting
format, for example:

[H] WBS Concept

[1] 1 CONSTRUCTION (Fill: Black, Font: White, Bold)
[2] 1.1 Floor slab (Fill: Grey, Font: Black, Bold)
[3] 1.1.1 10 cms. slab (Fill: none, Font: Black)
[3] 1.1.2 15 cms. slab (Fill: none, Font: Black)
[2] 1.2 Walls (Fill: Grey, Font: Black, Bold)

How can I tell to Excel that the unit price of [1] is the sum of all [2]'s
until i get to the next [1]. The unit price of [2]'s is equal to the sum
of
all [3]'s until i get to a [2] or a a [1]? So in that way i just assign
the
numbers and i am automatically generating subtotals and total?

,thanks.