Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Ed
 
Posts: n/a
Default "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.
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill
 
Posts: n/a
Default "Autosum until", help please!

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.


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 03:25 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"