Results 1 to 11 of 11
  1. #1
    2 Star Lounger
    Join Date
    Feb 2007
    Location
    Vienna, Wien, Austria
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts
    hi all,

    I have a severe problem with a huge list of worksheets to sum
    the entities in them. As You can see in the example, there might be about 4 or more entities
    to sum under a base entity and then to sum the base entities as well. i tried some things with
    sumif and sumproduct but there were only errors.... the base looks like pivot entities, but i shall
    not use pivot at work.... Your help would be appreciated....


    stef
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Why can't you use a pivot table?

  3. #3
    2 Star Lounger
    Join Date
    Feb 2007
    Location
    Vienna, Wien, Austria
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts
    first of all company policy....

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Then it's time to change the company policy.

  5. #5
    2 Star Lounger
    Join Date
    Feb 2007
    Location
    Vienna, Wien, Austria
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts
    no chance for me getting the budget ready til friday 12am....
    with 26 sheets like this....

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The data format is not particularly handy, but I've attached a possible solution. Still an enormous amount of work though. I have moved the grand total to the top, and changed the values in the entity column.

    [attachment=82637:SumEntity.xls]
    Attached Files Attached Files

  7. #7
    2 Star Lounger
    Join Date
    Feb 2007
    Location
    Vienna, Wien, Austria
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cool

    so, You used a project structure to simulate this.....

    Have You ever heard of Your relation to wizardry??? Thanks a lot for
    this, now i know how to handle...

    Thank YOU!!!!!

    best regards,
    stefan

  8. #8
    2 Star Lounger
    Join Date
    Feb 2007
    Location
    Vienna, Wien, Austria
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts
    so, now i am testing Your ingenious solution and i hope, that there is no gap, if i have more than 10 entities...

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    [quote name='Stefan_Sand' post='763456' date='04-Mar-2009 22:26']so, now i am testing Your ingenious solution and i hope, that there is no gap, if i have more than 10 entities...[/quote]
    My suggestion only works with less than ten items per level.

  10. #10
    2 Star Lounger
    Join Date
    Feb 2007
    Location
    Vienna, Wien, Austria
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts
    maybe i should expand it and divide with 100?? i will try... thanks

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    [quote name='Stefan_Sand' post='763463' date='04-Mar-2009 22:40']maybe i should expand it and divide with 100?? i will try... thanks[/quote]
    Yes, you could use 1, 101, 10101 etc. and divide by 100.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •