Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
"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. |