"Autosum until", help please!
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.
|