"Autosum until", help please!

[Guest]

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.

 

[Suzanne S. Barnhill]

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

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.