| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - Calculating quantities in a hierarchy
Hello,
I have a rather complex question but limited experience with excel. I have a family tree type of file and need to calculate costs based on the lower level costs. Example: Level 1 AAAA sum of levels 2 ($17) Level 2 BBBB $5 Level 2 CCCC sum of levels 3 ($12) Level 3 DDD sum of level 4 ($5) Level 4 EEE $5 Level 3 FFF $7 Each record has the level code and an indicator to tell if it's a sum or if it has the cost. I'm able to do this manually but the files can become large and this takes a while to process, level by level. Hopefully this make sense and there's an easy way to do this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hierarchy table | Excel Discussion (Misc queries) | |||
| Displaying Excel data in flattened hierarchy | Excel Worksheet Functions | |||
| Need ActiveX hierarchy. | Excel Discussion (Misc queries) | |||
| Hierarchy in excel | Excel Discussion (Misc queries) | |||
| Hierarchy in excel | New Users to Excel | |||
Threaded Mode
