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 / (Format)

[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 [1]? So in that way I just assign the
numbers and I am automatically generating subtotals and so on?

,thanks.