+ Reply to Thread
Results 1 to 3 of 3

Sum Multi tier selection

  1. #1
    Registered User
    Join Date
    07-27-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Smile Sum Multi tier selection

    I have two multi selection lists, one dependent on the first. A few questions,

    How do I filter the second list based on the multiple selections from the first list
    How do I then loop through the multiple selections from the second list against the same column on another sheet and sum values

    Example:
    List One is Org Level 1, and should allow for multiple selection
    05
    06
    10
    18
    etc..

    List Two is Org Level 2 and there is a one to many relationship to Org Level 1 - again, multiple selections allowed here
    Org 1 of 05 has Org Level 2 of 0510, 0520, 0540 etc..

    I am trying to sum active employee count based on the selected Org Levels - this data looks like the following:

    Org Level 1 Column A Org Level 2 Column B Headcount

    05 0510 23
    05 0520 5
    05 0540 4
    06 0603 18

    And so on...

    So I want to loop through the multiple selections made in the second list, and sum headcount

    Many Many Thanks!!!!

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Sum Multi tier selection

    Hello CLC,

    Welcome to the Forum!

    It will be easier to answer your questions if you post your workbook.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    07-27-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Sum Multi tier selection

    Thanks - here is an example...
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1